Migration & Consolidation from DB2 to MS SQL

  • Hi all,

    Does any body have a documentation or references for Migration & Consolidation from DB2 to MS SQL ?


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • Hi Helen,

    Are you migrating data from DB2 to MS SQL Server?  Or are you migrating an application from DB2 to MS SQL Server?

    Migrating data is not particularly difficult using either a commercial ETL tool or a set of custom DTS packages.

    Migrating an application is a bit more challenging.  I have done both in the past as a consultant. 

    SQL Server and DB2 use common terminology, but with different meanings in a few cases.  DB2 SQL is slightly different than MS SQL.  Implementation of things like federated databases versus linked servers is different.  Both platforms can handle all of the same things - implementation is significantly different in some cases.

    Please tell us a little more about what you are doing and we can provide a bit of support.

    Hope this helps

    Wayne

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

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