Printable View
I've read about using starsql odbc and sql server 7.0 DTS utility to transfer the database or data from a DB2 to SQL Server.
I have a SQL Server 6.5 and need to transfer data from a DB2. Is the operation the same? Is there a utility in sql server 6.5 that allows this?
Transfer Manager in 6.5 is the closest thing it has to DTS in 7.0. However, it does not have all the OLE DB stuff that DTS has.
Your best bet would be to export your DB2 tables to flat files and then BCP them into SQL server with transfer manager or the BCP utility.......
------------
Lisa at 6/27/00 1:59:04 PM
I've read about using starsql odbc and sql server 7.0 DTS utility to transfer the database or data from a DB2 to SQL Server.
I have a SQL Server 6.5 and need to transfer data from a DB2. Is the operation the same? Is there a utility in sql server 6.5 that allows this?