Export data from Informix to MS SQL
Posted in 2003
Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET
I apologize up front if this is a really dumb question but I am a total newbie to Informix databases. The company I work for stores it's call center data stored in an Informix database. We are forced to use their application to retrieve the data we want, and it is very limited. I am totally new to Informix; all of my database work I have done has been using MS SQL. Is there anyway to export my data (I only have 2 tables in the Informix database that I have access to) from Informix to my MSSQL database. The ideal end result would be to display it on the web. I have looked everywhere to find ODBC drivers for Informix and can't find any. Also, is there an equivalent to Enterprise manager for Informix? Thanks for any suggestions
Look for IConnect on the IBM website, the ODBC drivers are in there. Chris wrote: > > I apologize up front if this is a really dumb question but I am a > total newbie to Informix databases. The company I work for stores > it's call center data stored in an Informix database. We are forced > to use their application to retrieve the data we want, and it is very > limited. I am totally new to Informix; all of my database work I have > done has been using MS SQL. Is there anyway to export my data (I only > have 2 tables in the Informix database that I have access to) from > Informix to my MSSQL database. The ideal end result would be to > display it on the web. I have looked everywhere to find ODBC drivers > for Informix and can't find any. Also, is there an equivalent to > Enterprise manager for Informix? Thanks for any suggestions -- Paul Watson # Oninit Ltd # Growing old is mandatory Tel: +44 1436 672201 # Growing up is optional Fax: +44 1436 678693 # Mob: +44 7818 003457 # www.oninit.com #