Re: Re: How to export an Informix db to MS SQL Server 2000?
You could do DTS,but you will run into troubles if the data to be migrated is big... It will need a lot of logical logs... If you know how to deal with this issue do it through DTS is easy. Chucho! -----Original Message----- From: "Jack A" <jacka8@excite.com> To: informix-list@iiug.org Date: Mon, 25 Aug 2003 21:05:48 GMT Subject: Re: How to export an Informix db to MS SQL Server 2000? 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. Jean Sagi jeansagi@myrealbox.com jeansagi@netscape.net sending to informix-list
Just curious. What does the "chucho!" at the end of your post mean ? "Jean Sagi" <jeansagi@myrealbox.com> wrote in message news:bifkgl$k3q$1@terabinaries.xmission.com... > > > You could do DTS,but you will run into troubles if the data to be migrated is big... It will need a lot of logical logs... > > If you know how to deal with this issue do it through DTS is easy. > > Chucho! > > -----Original Message----- > From: "Jack A" <jacka8@excite.com> > To: informix-list@iiug.org > Date: Mon, 25 Aug 2003 21:05:48 GMT > Subject: Re: How to export an Informix db to MS SQL Server 2000? > > 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. > > > > > Jean Sagi > jeansagi@myrealbox.com > jeansagi@netscape.net > > > sending to informix-list