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 (AT) boxfrog (DOT) com> wrote

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 (AT) excite (DOT) com> wrote

You need some ODBC drivers. They are part of SDK which is free.
Download install SDK and configure IConnect, then configure an ODBC driver.
Use the DTS wizard to migrate the data.

MW

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 (AT) excite (DOT) com>
To: informix-list (AT) iiug (DOT) 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 (AT) boxfrog (DOT) com> wrote




Jean Sagi
jeansagi (AT) myrealbox (DOT) com
jeansagi (AT) netscape (DOT) net


sending to informix-list

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 (AT) boxfrog (DOT) com> wrote

Just curious. What does the "chucho!" at the end of your post mean ?

"Jean Sagi" <jeansagi (AT) myrealbox (DOT) com> wrote

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 (AT) excite (DOT) com]
Sent: Tuesday, August 26, 2003 8:45 AM
To: informix-list (AT) iiug (DOT) 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 (AT) boxfrog (DOT) com> wrote

sending to informix-list

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 (AT) excite (DOT) com> wrote

Thanks for the road map. Well, when you say SDK, who's SDK?
quality-wise, all ODBC driver companys' product(SDK) is about the
same? Secondly, other folks did not mention that IConnect is
necessary, that's the relation between IConnect and an ODBC driver for
Informix?

"Murray Wood \(IList\)" <ifxmaillist (AT) quanta (DOT) co.nz> wrote