Share via

Use SSMA for DB2 to Migrate AIX DB2 11.5.9 to SQL Server 2019

Robert Carter 0 Reputation points
2024-04-09T20:16:55.67+00:00

Is it possible to use the SSMA tool to migrate an AIX DB2 (Big endian) to Windows SQL Server 2019 (little endian)?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,005 questions
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.
502 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LucyChenMSFT-4874 1,935 Reputation points
    2024-04-10T03:05:01.99+00:00

    Hi @Robert Carter,

    Thanks for your information.

    For supported sources, I review the information on the Download Center for the SSMA download. Please look at this:

    User's image

    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 2022, Azure SQL Database and Azure SQL Database Managed Instance.

    And the following target versions are supported for SSMA:User's image

    Please check out your version of sources and target. Here is an article of migrating DB2 databases to SQL Server, hope it can help you well.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications