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

    Question Unanswered: DB2 to SQL migration

    Can anyone help with a reccomendation of tool to migrate meta data from DB2 to SQL?

    Many thanks
    Si

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by Simon Cav View Post
    Can anyone help with a reccomendation of tool to migrate meta data from DB2 to SQL?

    Many thanks
    Si
    Do you mean MS SQL Server? SQL is the interface language used by all relational databases, and was invented by IBM.

    If you mean migrate to SQL Server, I would contact MS.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    If both server are on same network or if you can create a linked server from SQL to db2 you can easily migrate all data from DB2.You can use the LOAD or IMPORT commands. See the manuals on how to use them.

Posting Permissions

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