Transferring data to SQL Server 2000
Transferring data to SQL Server 2000
(OP)
I have an Informix 9.3 database and need to output some of the data in xml. As this does not appear possible via Informix I want to automatically transfer the data from Informix to SQL Server where I can then output it to xml.
Any ideas to do this?
Thanks
Any ideas to do this?
Thanks
RE: Transferring data to SQL Server 2000
In the early 90's using Window's 3.1 I used a third-part product called datajunction to move between Oracle, Informix, Sybase, and several other products.
I haven't dealt with them in years, but you might want to check them out. http://www.datajunction.com
Regards,
Ed
Schaefer
RE: Transferring data to SQL Server 2000
Install the Informix CLI client and you should have an ODBC driver for Informix.
Now in the SQL Server DTS (enterprise manager), You can create a package that "SELECT"s from the Informix server and the puts it in the SQL server.
RE: Transferring data to SQL Server 2000
Thanks