SQL Server Performance Forum – Threads Archive
Informix to SQL 2005
Hi everyonewe are trying to migrate the informix database to SQL 2005. So can anyone tell me wher i can find the drivers to import the data. thank you in advance
Preethi
YOu can create the linked server using ODBC…. http://groups.google.com/group/micr…ver to informix&rnum=3&hl=en#cf38a4441292e880 http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/infmxsql.mspx
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
If you can wait MS is releasing the Migration Assistant for DB2 & Informix too, if interested register to https://profile.microsoft.com/RegSysProfileCenter/wizard.aspx?wizid=2c4bcd53-42ed-4643-acab-343de924da2b&lcid=1033 andhttp://www.microsoft.com/sql/solutions/migration/default.mspx for more information. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I installed the drivers and when i try to set the properties of the driver and test the connection it says the connection failed because of an error in initialising the provider. what would be the cause for this??
Post the error for complete description. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>