Question

A company is migrating a 900 GB SQL Server 2019 database from an on-premises server to Azure SQL Managed Instance. The business requires that application downtime be limited to a short cutover window, with the source database remaining available and continuously synchronized until the final switchover. Which migration approach should you use?

Accepted Answer

Use the Azure SQL Migration extension in Azure Data Studio with Azure Database Migration Service in online migration mode

Answer

Take a full native backup, copy it to Azure Blob Storage, and restore it to the Managed Instance using RESTORE FROM URL

Answer

Use the BACPAC export/import feature to move the schema and data to the Managed Instance

Answer

Use the Azure SQL Migration extension in Azure Data Studio with Azure Database Migration Service in offline migration mode