Updating from an Informix Source
-
My requirement:
I need to continuously update a SQL Server database from the source data that is on Informix.
What are the possible alternatives to do the job?
If somebody have done it before, please provide inputs of how it was done?
This is what I've gathered sofar:
Microsoft site says SQL Server also includes an ODBC driver that supports Informix subscriptions to SQL Server, but I did't find one from the new install of SQL Server or from microsoft website.
Like, DB2 has DB2 Connect to connect to DB2 from SQL Databases...I,ve seen Informix Connect on IBM website...It finally leads me to loading of Informix client tools on the destination SQL Server...
Appreciate your help...
CSB
-
This was removed by the editor as SPAM
-
Sorry it took so long to repond to this, I'm a little behind going through the Community Updates.
It's been a few years but I migrated from Informix to SQL Server a few years back. You get an ODBC driver from sources other than Microsoft. I used to use the Intersolv driver but there are other ones out there. Once you have the ODBC driver there are many options. You can use dts to move data between Informix and SQL-Server. I suppose it would be possible to link the SQL-Server to the Informix database as well. I've also unloaded tables from informix into flat files and used bcp to load it into SQL Server.
I would do a google search for "Informix ODBC" and start there.
-
I was looking for a way to do a join between an informix and sql server databases and found this question; I may be able to help.
We update from informix to sql2k all the time through ODBC, using the driver that appears in the list as "INFORMIX 3.81 32 bit"
You will have to get several items from the Informix DBA to enter into your ODBC Driver Setup, such as
Server Name
Host Name (usually an IP address)
Service (i think this is a port #)
protocol
database name
The Informix DBA must also give you a User ID and Password.
I hope this helps.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply