QuestionQ42

VerifiedAccelerate Workload Migration and Modernization

A solutions architect plans to migrate critical Microsoft SQL Server databases to AWS. Since the databases are legacy systems, the solutions architect will move them to a modern data architecture. The solutions architect must complete the database migration with near-zero downtime.

Which solution meets these requirements?

Explanation

Native Microsoft SQL Server high availability tools (Always On Availability Groups, distributed availability group clusters) provide true active-active replication to Amazon RDS for Microsoft SQL Server, achieving near-zero downtime during cutover by leveraging synchronous transactional replication. While setup requires careful coordination, native tools preserve application compatibility and offer the closest approach to zero-downtime migration. AWS DMS full-load-plus-CDC provides limited-downtime capability, but native SQL Server replication is the gold standard for the lowest RTO and RPO in SQL Server migrations.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!