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

    Unanswered: Transferring data to DB2 on Linux


    This question may be a bit naive but I have some data that I would like to transfer from a SQL 7 database to a DB2 database on Linux. Does anyone know how I would go about doing this. I have in the past transferred data from SQL 7 to Oracle and SYBASE using DTS without any difficultly. I cannot remember exactly but presume they were on NT.

    Anyone got any ideas/suggestions.

    Many thanks

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    As long as you can get ODBC drivers for a database, DTS is the way to go!

    If you can't get them, then you need to look at brute force... Dumping the data to flat files, moving the files to the target environment, then loading them into the target server. In a work, Ick!


Posting Permissions

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