Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2009
    Posts
    2

    Question Unanswered: DB2 to SQL migration

    Could anyone help with a recommendation of a tool to migrate meta data from DB2 to SQL?


    Many thanks
    Si

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What do you mean by Meta data?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I don't know of any product that will automatically do this that is also foolproof. In most cases (probably more than ninty five percent), using anything other than the vendor provided tools is massive overkill.

    I'm comfortable in both DB/2 and MS-SQL, so I use the tools that they provide. DB2-Connect will provide DDL for the objects in the DB2 schema. You probably only want the tables and views. Once they've been saved as SQL Scripts, open those scripts and play them into an empty SQL Server database using SQL Server Management Studio.

    There are tools that will help automate the conversion. The Enterprise Architect Edition of Microsoft Visio does a credible job. At least in my mind, the "800 pound gorilla" of cross platform database/schema tools has always been ErWin which I beleive is currently owned by Computer Associates... ErWin can handle any schema problem that I've ever seen, including SAP and PeopleSoft.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ERWin is my tool of choice....

    It'll take your DDL from DB2, and create a SQL Server version of the DDL

    I don't I found it to do 100%...you always want to tweak something

    So is the DDL the metadata you are asking about?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    You can use DB2LOOK to extract all tables, views, triggers, constraints, functions, procedures, ... from your DB2 database. After some tweaking you can run them in SQL Server.
    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

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    After some tweaking?

    You're freakin hilarious

    And why don't know what platfrom they are on yet
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    After some tweaking?

    You're freakin hilarious
    Read my disclaimer
    Beware of bugs in the above code; I have only proved it correct, not tried it.
    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
  •