Post reply

Data Migration

  • September 10, 2004 at 3:30 am

    #162205

    Hi, I would like to get an idea about the data migration from DB2 to SQL Server - I have very little idea about DB2 but working knowledge in SQL Server. Please don't be cryptic in answering the query.

    You are welcome to write directly to me dasamitava@hotmail.com or post the reply here only.

    Thanks in advance

    Amitava

     

  • September 13, 2004 at 6:47 am

    #522721

    You can use Data Transformation services to move tables from most any other database to SQL server. You will need an odbc connection to the DB2 server. DTS is pretty good about laying out the schema for you, but you will need to make sure that keys are setup properly when it defines your destination tables. When it sets up the destination table for you, you can make changes to it before it is created.

     

Viewing 2 posts - 1 through 1 (of 1 total)

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