Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

INFORMIX <---> SQL Server

Status
Not open for further replies.

pascalfaricier

Programmer
Joined
Oct 1, 2001
Messages
1
Location
FR
Is it possible to import an informix database to SQL Server?
i only have the solution to pass throw oracle :

informix-->oracle
and then
oracle--->SQLServer...

PLEASE, this is very important.
Pascal F
 
The simpleset would be to use the SQL server DTS,
and select source as other connection.
Of course you will need an ODBC driver for Informix for this.

or

i guess you can also use unload command to export to a file,
the transfer the file using FTP and use DTS to import.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top