You have an on-premises deployment of SAP on DB2. You plan to migrate the deployment to Azure and Microsoft SQL Server 2017. What should you use to migrate the deployment?

Question

Options

• ASQL Server Migration Assistant (SSMA)
• BAzure SQL Data Sync
• Cdb2haicu
• DDSN1COPY

• A
  90% (43)
• B
  2% (1)
• C
  2% (1)
• D
  6% (3)

Explanation

SQL Server Migration Assistant (SSMA) is Microsoft's purpose-built tool for migrating databases from non-SQL-Server platforms - including DB2 - to SQL Server or Azure SQL. It handles schema conversion, data migration, and compatibility assessment, making it the correct end-to-end solution for this DB2-to-SQL-Server 2017 scenario.

Why the distractors are wrong:

• B. Azure SQL Data Sync is for ongoing synchronization between SQL databases already in Azure/SQL Server - it doesn't migrate from DB2.
• C. db2haicu is IBM's High Availability Instance Configuration Utility for DB2 clustering - it manages DB2 HA setups, not cross-platform migrations.
• D. DSN1COPY is an IBM z/OS utility for copying DB2 table spaces on mainframes - completely unrelated to migration to SQL Server.

Memory tip: Think of SSMA as the "translator" - it speaks DB2 (and also MySQL, Oracle, Access, Sybase) and converts everything into SQL Server's language. If you're crossing database platforms and landing on SQL Server, SSMA is almost always the answer on Azure/Microsoft exams.

No community discussion yet for this question.