How can i Migrate a database from DB2 to SQL Server 2008r2. RRS feed

  • Question

  • Hi Gurus,

    Kindly help me letting me know the process for migrating the database from DB2 to SQL Server.

    1) Is there any way to migrate a database from DB2 to SqlServer. (My assumption is we can not migrate database, if wrong correct me gurus).

    2) Or we can only transfer data from that DB2 database to SQL Server (Using SSIS packages).

    Please help me knowing the process to migrate the data from DB2 server to MSSQL server. Even am reading the documents available in the web.

    Thanks in advance.. :)

    Thursday, March 26, 2015 12:25 PM


  • Microsoft provide a migration assistant for DB2 to SQL Server:


      SQL Server Migration Assistant (SSMA) is a free supported tool from Microsoft that simplifies database migration process from DB2 to SQL Server and Azure SQL DB. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion and data migration. 

    Hope that helps

    Thursday, March 26, 2015 12:50 PM