Suggestions to migrate db2 9.5 to SQL server using SSMA ?

ManjunathSadashivappaHavaldar-8703 1 Reputation point
2022-09-14T05:19:10.913+00:00

Can you help me provide some suggestions to migrate db2 9.5 to SQL server using SSMA please.

Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
495 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 13,436 Reputation points Microsoft Employee
    2022-09-14T08:46:47.47+00:00

    Hi @ManjunathSadashivappaHavaldar-8703 ,

    Welcome to Microsoft Q&A platform and thanks for using Azure Services.

    Regarding your ask about DB2 migration to SQL Server using SQL Server Migration Assistant (SSMA), the documentation says:

    SSMA for DB2 is designed to support migration from DB2 on z/OS versions 9.0 and 10.0, DB2 on Linux/Unix/Windows (LUW) versions 9.7 and 10.1 and DB2 for i version 7.1 and higher to SQL Server 2012 through SQL Server 2019, Azure SQL Database and Azure SQL Database Managed Instance.

    System Requirements and Install Instructions are present at this link.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
  2. Alberto Morillo 32,891 Reputation points MVP
    2022-09-14T10:48:21.66+00:00

    Please make sure to install the latest version of SSMA. If you have an old version of SSMA, proceed to uninstall it and then download and install the latest version.

    The easiest way to craft correct connection string for SSMA to connect to DB2 is to use the Data Access Tool. If you need to connect to DB2 with SSL enabled, you may want to provide "Certificate Common Name" to enable SSL/TLS in the provider.

    When migrating DB2 columns defined as INTEGER NOT NULL GENERATED BY DEFAULT AS IDENTITY you may find SSMS converts them just as Integer not as identity columns. In this scenario you may have to manually update the generated schema for the SQL server/SQL Azure to add the Identity attribute.