Post reply

Migrating from DB2 To SQL2000

  • September 27, 2005 at 1:11 pm

    #165344

    Hi friends!

    I am looking for a solution for migrating from AS400 DB2 to SQL2000, i found on MS Page the SSMA tool, but only works for Oracle. Anyone knows some cool tools to accomplish this? I prefer to migrate the data and structure, dont use a DTS strategy.

    Thanks all.

  • September 28, 2005 at 5:52 am

    #593610

    You can try Adventnet's tool:

    http://www.swissql.com/products/db2-to-sqlserver/db2-to-sql-server.html

    Such tools typically do 50-60% of the work for you and still require a lot of input from people who know what DB2/AS-400 and SS2k have to offer.

  • September 28, 2005 at 9:08 am

    #593706

    I would use a database designer like ERWin or ERStudio to make a structure and then would pump data either by DTS or intermediate dumps to flat files and use scripts to import data correctly. Actually, depends on the database size.

    Yelena

    Regards,Yelena Varsha

  • September 28, 2005 at 9:16 am

    #593711

    Thanks for the advice, i was trying the EMS SQL Datapump and works fine...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply