You have an on-premises SAP NetWeaver landscape that contains an IBM DB2 database. You need to migrate the database to a Microsoft SQL Server instance on an Azure virtual machine. Which tool should…

Question

Options

• AData Migration Assistant
• BSQL Server Migration Assistant (SSMA)
• CAzure Migrate
• DAzure Database Migration Service

• A
  4% (1)
• B
  93% (25)
• D
  4% (1)

Explanation

SQL Server Migration Assistant (SSMA) is the right tool because it's Microsoft's purpose-built utility for migrating heterogeneous databases - including IBM DB2, Oracle, MySQL, and others - directly to SQL Server. SSMA handles schema conversion, data migration, and compatibility assessment specifically for cross-platform SQL Server migrations.

Why the distractors are wrong:

• A. Data Migration Assistant (DMA) assesses and migrates SQL Server to SQL Server (or Azure SQL); it doesn't support source databases like DB2.
• C. Azure Migrate is a broader discovery and assessment tool for lifting on-premises workloads (VMs, apps) to Azure - it's not a database conversion tool.
• D. Azure Database Migration Service supports migrations to Azure managed database services (Azure SQL DB, Azure SQL MI, Azure Database for MySQL, etc.) - not to SQL Server on an Azure VM, and has limited support for DB2 as a source.

Memory tip: Think of SSMA as the "polyglot translator" - it converts other database engines into SQL Server. If the source is non-SQL-Server and the target is SQL Server (even on a VM), SSMA is your answer. DMA is the "same-family upgrader," and Azure Database Migration Service is the "managed-service mover."

No community discussion yet for this question.