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

Posted in 2003

Doug Baroter — 25 Aug 2003 13:40:22 -0700 — source: Usenet: comp.databases.informix

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.

↪ replying to Doug Baroter

Jack A — Mon, 25 Aug 2003 21:05:48 GMT — source: Usenet: comp.databases.informix

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.

↪ replying to Jack A

Doug Baroter — 25 Aug 2003 19:07:27 -0700 — source: Usenet: comp.databases.informix

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.

↪ replying to Doug Baroter

Jack A — Tue, 26 Aug 2003 12:44:52 GMT — source: Usenet: comp.databases.informix

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.

↪ replying to Jack A

Doug Baroter — 26 Aug 2003 11:47:06 -0700 — source: Usenet: comp.databases.informix

Thanks. I'll try Merant driver first since they're available now, if it fails or not to satisfactory, then try the ones in the order you listed. BTW, could you do a quick run-down on a generic quick, dirty search component that I developed (for non-trasactional database), this is a basic version, http://68.32.61.40/datadata/ddSearch.cfm (available most of time) Thanks. "Jack A" <jacka8@excite.com> wrote in message news:<878b26ce7870b91c3ea22db0cd507249@news.teranews.com>... > 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.