Azure SQL Server DBA

Migration: Methods & Tooling

Question

Azure DMS offline versus online migration: how do their Azure SQL targets differ?

Answer

Offline migration transfers data while the source is unavailable for cutover; use it for Azure SQL Database or Managed Instance when downtime is acceptable. Azure DMS online migration continuously synchronizes before cutover; use it for Azure SQL Managed Instance when downtime must be minimized.

This is 13 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples