I am trying to migrate data from an Informix database to SQL Server 2008. I've got quite a lot of data to move. I've been try multiple methods to get the data over, and so far SQLBulkCopy in multiple chunks seems to be the fastest that I can find. Does anyone know of a faster means of getting the data over? I'm trying to cut down on the transfer time so that on my cut-over date I don't run out of time to do the full cut-over. Thanks.
A:
There isn't much more you can do to get this work completed faster. One thing you might want to look at though is the recover model for the sql database. If it's currently set to Full, you're going to end up slowing down quite a bit as the transaction log fills up.
http://msdn.microsoft.com/en-us/library/ms189275.aspx
Hope that helps.
Jeff Schumacher
2010-05-25 04:31:09
+1
A:
As you mentioned, I think that the bcp command is the fastest solution. you can make csv file from your data and then import those to your db by bcp command.
masoud ramezani
2010-05-25 11:06:42
Unfortunately, cannot make a cvs file as the table has binary data.
Fred Clown
2010-05-29 00:24:46
A:
If you can use an Ole or ODBC connection to your Informix database, then SSIS may be the best option.
ck
2010-05-25 11:10:47