Question

A retail company runs a legacy line-of-business application on SQL Server 2008 R2 hosted on-premises. The database is 300 GB and is used only during store hours (7 AM to 9 PM). Management has approved a scheduled overnight maintenance window and wants to migrate the database to Azure SQL Managed Instance with the least operational complexity. You must recommend the migration approach that meets these requirements while minimizing cost and effort. Which approach should you recommend?

Accepted Answer

Perform an offline migration using the Azure SQL Migration extension in Azure Data Studio during the maintenance window

Answer

Perform an online migration using the Azure SQL Migration extension with continuous log shipping so the application stays available

Answer

Configure a Distributed Availability Group between the on-premises instance and the Managed Instance for continuous replication

Answer

Use transactional replication from SQL Server 2008 R2 to the Managed Instance to keep data synchronized until cutover