RE: How to export an Informix db to MS SQL Server 2000?

I use the intersolv ODBC driver to facilitate a DTS package of our informix DB for inclusion into our datawarehouse in SQL. It works fairly well exporting 7Gigs in just over an hour. -----Original Message----- From: Jack A [mailto:jacka8@excite.com] Sent: Tuesday, August 26, 2003 8:45 AM To: informix-list@iiug.org Subject: Re: How to export an Informix db to MS SQL Server 2000? DataDirect has good ODBC drivers. I have used them. Merant ODBC drivers are also good. I've used them too. Intersolv is another company you can try. They're in the ODBC business too. "Doug Baroter" <qwert12345@boxfrog.com> wrote in message news:fc254714.0308251807.64d0c39f@posting.google.com... > Searched MS site did not yield anyting meaningful. Do you happen to > know any other company that has reliable ODBC driver to connect to > Informix? I know my system has ODBC driver for Informix from Merant > (version 3.7), I can't tested it now, have you ever used it, any good? > Thanks. > > "Jack A" <jacka8@excite.com> wrote in message news:<6f4b8212ac95991e6d6c618bb760a89c@news.teranews.com>... > > Why dont you use DTS available in Sql Server ? Get the ODBC driver for > > Informix from Microsoft or some one else. Set up a DTS package using > > Informix as the Source and MS Sql Server as the target. Once you set up the > > DTS it will migrate all the data for you. > > > > "Doug Baroter" <qwert12345@boxfrog.com> wrote in message > > news:fc254714.0308251240.6768915a@posting.google.com... > > > Hi, > > > > > > My client has an Informix SE database on Windows Platform (NT). How > > > do I export such a db to MS SQL Server 2000? I've searched this NG, > > > someone mentioned about setting up i-connect driver, however, I > > > couldn't find such as a driver from IBM web site to download. > > > > > > Thanks. sending to informix-list