What should you use to export from DB2 and import the data to SQL Server?

You have an on-premises SAP environment that uses AIX servers and IBM DB2 as the database platform.

You plan to migrate SAP to Azure. In Azure, the SAP workloads will use Windows Server and Microsoft SQL Server as the database platform.

What should you use to export from DB2 and import the data to SQL Server?
A . R3load
B . Azure SQL Data Warehouse
C . SQL Server Management Studio (SSMS)
D . R3trans

View Answer

Answer: C

Explanation:

To migrate DB2 databases to SQL Server, you must connect to the DB2 database that you want to migrate. When you connect, SSMA obtains metadata about all DB2 schemas, and then displays it in the DB2 Metadata Explorer pane.

References:

https://docs.microsoft.com/en-us/sql/ssma/db2/connecting-to-db2-database-db2tosql?view=sql-server­ver15

https://docs.microsoft.com/en-us/biztalk/adapters-and-accelerators/adapter-sap/import-sap-data-using-sql­server-management-studio