How to export an Informix db to MS SQL Server 2000?
Doug Baroter asked how to export an Informix SE database on Windows NT to MS SQL Server 2000. Jack A suggested a DTS package using an Informix ODBC driver, and named DataDirect, Merant and Intersolv as good driver vendors. Doug planned to try the Merant 3.7 driver he already had and asked for feedback on his search component. Outcome not reported.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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.
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.
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.
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.
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.