SSMA - Convert adhoc DML and DDL queries

Question

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

Answer 1

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