You have an on-premises Microsoft SQL server named SQL1 that hosts 50 databases. You plan to migrate SQL1 to Azure SQL Managed Instance. You need to perform an offline migration of SQL1. The…

The correct answer is D. Azure Database Migration Service. This Azure service supports migration in the offline mode for applications that can afford downtime during the migration process. Unlike the continuous migration in online mode, offline mode migration runs a one-time restore of a full database backup from the source to the…

Submitted by yuki_2020· Mar 6, 2026Design data storage solutions

Question

You have an on-premises Microsoft SQL server named SQL1 that hosts 50 databases. You plan to migrate SQL1 to Azure SQL Managed Instance. You need to perform an offline migration of SQL1. The solution must minimize administrative effort. What should you include in the solution?

Options

ASQL Server Migration Assistant (SSMA)
BAzure Migrate
CData Migration Assistant (DMA)
DAzure Database Migration Service

How the community answered

(58 responses)

A
7% (4)
B
5% (3)
C
2% (1)
D
86% (50)

Explanation

This Azure service supports migration in the offline mode for applications that can afford downtime during the migration process. Unlike the continuous migration in online mode, offline mode migration runs a one-time restore of a full database backup from the source to the target https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server- to-managed-instance-overview?view=azuresql#compare-migration-options

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice