Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: how do you import a blob column from Sql server 2000 to UDB 8.1

    I am undergoing a migration excercise from SQL SERVER 2000 to UDB DB2 8.1

    We have some tables in SQL SERVER which are BLOB and VARBINARY.
    What would be good way to extract that data from SQL SERVER and load it into DB2.

    I tried using BCP at the sql server end to export the data from the tables and then I used an import at the DB2 end to load the data in.
    The import was successful but then the import also added a few characters to the BLOB datas.

    Any suggestions would be greatly appreciated.


  2. #2
    Join Date
    Nov 2003
    How about using DB2 II with MS-SQL Wrapper.
    It import SQL-Server data ( text, Image, .. ) with DB2 CLOB or BLOB.

Posting Permissions

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