Question
Your company has an on-premises SQL Server database that contains 500 GB of data. You need to migrate the database to Azure SQL Database with minimal downtime.
The solution must:
- Support continuous synchronization during migration
- Allow you to switch over when ready
- Minimize application changes
Which migration approach should you use?
A. Azure Database Migration Service online migration
B. BACPAC export and import
C. SQL Server backup and restore
D. Azure Data Factory copy activity
- A. Azure Database Migration Service online migration Correct
- B. BACPAC export and import
- C. SQL Server backup and restore
- D. Azure Data Factory copy activity
Explanation
Azure Database Migration Service with online migration mode supports continuous sync and minimal downtime cutover.