Share via

SSMA - Convert adhoc DML and DDL queries

Santo, Nuno 0 Reputation points
2024-07-24T17:03:00.64+00:00

Hello,

Does Microsoft SQL Server Migration Assistant (SSMA) provide a way to convert an ah-doc DML or DDL query from DB2 z/OS syntax to MS SQL Server?

By other means, I have an application that today has queries that execute on a DB2 z/OS and after the database is migrated to SQLServer, these queries need to adjusted. The question is this tool helps in this process.

Thank you

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,367 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.
517 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 25,651 Reputation points
    2024-07-25T01:51:39.3133333+00:00

    Hi @Santo, Nuno

    Yes, SSMA assists in migrating the database schema (DDL) to SQL Server-compatible schema and data (DML) from DB2 to SQL Server.

    To publish your schema and migrate your data, perform the following steps:

    1. Publish the schema. On the SQL Server Metadata Explorer pane, right-click the database, and then select Synchronize with Database.
    2. Migrate the data. On the Db2 Metadata Explorer pane, right-click the schema or object you want to migrate, and then select Migrate Data.
    3. Provide connection details for both the Db2 and SQL Server instances.
    4. After the migration is completed, view the Data Migration Report.
    5. Connect to your SQL Server instance by using SSMS, and then validate the migration by reviewing the data and schema.

    Please refer to this doc for more details: Migration guide: IBM Db2 to SQL Server.

    Best regards,

    Cosmog

    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".

    0 comments