You have eight on-premises servers that have Microsoft SQL Server 2022 installed. Each server contains multiple databases. You plan to migrate the on-premises databases to Azure. You need to analyze…

Question

Options

• AData Migration Assistant (DMA)
• BSQL Server Migration Assistant (SSMA)
• CAzure Database Migration Service
• DAzure Migrate
• EDatabase Experimentation Assistant (DEA)

• A
  79% (26)
• B
  6% (2)
• C
  3% (1)
• E
  12% (4)

Explanation

[A] The Data Migration Assistant (DMA) can be used to identify which Azure SQL services are suitable for hosting your databases when migrating from SQL Server 2022 to Azure. DMA assesses your on-premises SQL Server databases and provides recommendations on whether they are compatible with Azure SQL Database or Azure SQL Managed Instance. It identifies potential migration blockers and compatibility issues, helping you choose the appropriate Azure [D] Azure Migrate can be used to identify which Azure SQL services are suitable for hosting your migrated databases. It assesses on-premises SQL Server databases for migration readiness, providing recommendations on target Azure SQL service options like Azure SQL Database (single database or elastic pool), Azure SQL Managed Instance, and SQL Server on Azure VMs. Azure Migrate also helps with performance-based sizing and cost estimations for running the databases in Azure. https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver17 https://learn.microsoft.com/en-us/data-migration/sql-server/database/guide

No community discussion yet for this question.