You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime. What should you do?

Question

Options

• AConfigure Transaction Log Shipping.
• BImplement Always On availability groups.
• CConfigure transactional replication.
• DImport a BACPAC.

• A
  4% (1)
• B
  4% (1)
• C
  77% (20)
• D
  15% (4)

Explanation

Use Transactional Replication. When you can't afford to remove your SQL Server database from production while the migration is occurring, you can use SQL Server transactional replication as your migration solution. Note: There are two primary methods for migrating a SQL Server 2005 or later database to Azure SQL Database. The first method (database copy or BACPAC importation) is simpler but requires some, possibly substantial, downtime during the migration. The second method (transactional replication) is more complex, but substantially eliminates downtime during the migration. Not D: The import BACPAC method includes downtime during migration. https://docs.microsoft.com/en-us/azure/azure-sql/database/migrate-to-database-from-sql- server#method-1-migration-with-downtime-during-the-migration

No community discussion yet for this question.