Help with importing data and structure, Informix to SQL Server 6.5

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

What is the best way to import database structure and data from INFORMIX into SQL server 6.5?

This process would be execute periodically.

-- Anonymous, October 09, 1998

Answers

Re: Importing from Informix

Jesus,

To import the database structure, use ERwin (or another modeling tool) to reverse engineer the database and then forward engineer it to SQL. Watch out for SQL Server's limit of 31 foreign key constraints. If you are above this limit you will need to remove the foreign key constraints before forward engineering.

To transfer the data you will need to use bcp (bulk copy) on the SQL side to read whatever format data you produce on the Informix side.

Good luck,

Eric

-- Anonymous, October 15, 1998


Moderation questions? read the FAQ