Post reply

Migration from DB2 8.1 to SQL Server

  • January 26, 2017 at 12:17 pm

    #320961

    Hi Friends,

    Can we use Microsoft SSMA 6.0 to migrate DB2 version 8.1 database to SQL Server?

    If not, could you please suggest some good alternatives?

    Thanks.

    Sujeet Singh

  • January 26, 2017 at 1:07 pm

    #1925180

    Divine Flame - Thursday, January 26, 2017 12:17 PM

    Hi Friends,

    Can we use Microsoft SSMA 6.0 to migrate DB2 version 8.1 database to SQL Server?

    If not, could you please suggest some good alternatives?

    Thanks.

    I have done this with SSIS but we had a way to create an ODBC connection to the DB2 database.
    Are you going to use SSMA as your virtual 3270 port and what is your connectivity to the DB2 environment?

    You will need to create and test Transformations in SSIS to convert from the datatype in DB 2 to a data type for your SQL server database.
    If you are not experienced in ETL and 3270 connectivity this will be a very large project.

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

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