Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    12

    Unanswered: Import DB from SQL Server 2000 to DB2

    Hello.
    I would like import a Microsoft Server database in a DB2. How can I do it.
    Is it possible to use a Wizard to realize this import action ?

    Than you

  2. #2
    Join Date
    Nov 2004
    Location
    Canada
    Posts
    58
    I would use a dts package to an odbc linked server (iseries driver or what ever driver you are using for data access on db2) then in your package assuming you have proper "write" credentials I would create a dts with multiple datapumps that create the tables and insert the data into db2 from your tables. Start by creating on Data transformation from one sql table to your db2 environment SQL source and DB2 destination, On the create table copy the syntax that appears in the data transform, then you can use that with execute sql task to create many at the same time (create your own parsing statement for all the tables you require from the database). Then instead of having several datapumps then you can have one large execute sql task script to do this. I would believe security would be different so permissions and security should be set up from the DB2 side. As far as doing a complete DB copy from SQL to DB2 I am not sure I would want to attempt this.

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    Quote Originally Posted by burkular View Post
    ... As far as doing a complete DB copy from SQL to DB2 I am not sure I would want to attempt this.
    Why not? What would you do as an alternative?
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

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