Question

Your company runs a 4 TB SQL Server 2016 database on-premises supporting a 24/7 e-commerce platform. Management requires migrating to Azure SQL Managed Instance with the least possible downtime, and the source database uses features not supported by Azure SQL Database. Which migration approach should you use?

Accepted Answer

Use the Azure Database Migration Service in online migration mode with a continuous log restore until final cutover

Answer

Take a full native backup, copy it to Azure Blob Storage, and restore it to the Managed Instance during a maintenance window

Answer

Use the BACPAC export/import method through SqlPackage to move the schema and data

Answer

Use the Azure Database Migration Service in offline migration mode with a single backup restore