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: A

Explanation:

Both R3load and SSMA can be used to migrate from DB2 to SQL Server. In the options there is not SSMA, but SSMS, the SSMS cannot be use to migrate DB2 to SQL Server. please refer to: https://techcommunity.microsoft.com/t5/running-sap-applications-on-the/sap-os-db-migration-to-sql-server-faq/ba-p/366986

https://sapnwnewbie.blogspot.com/2013/07/osdb-migration-cmd-str-toc-ext-r3load.html

https://docs.microsoft.com/en-us/sql/ssma/sql-server-migration-assistant?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-ssms?view=sql-server-ver15