Results 1 to 2 of 2

Thread: Transfering Data from DB2 to SQL Server

  1. #1
    Lisa Guest

    Transfering Data from DB2 to SQL Server

    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?

  2. #2
    Craig Guest

    Transfering Data from DB2 to SQL Server (reply)

    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •