A solutions architect is planning a heterogeneous database migration from an on-premises Microsoft SQL Server database to an Amazon Aurora PostgreSQL DB cluster. The migration strategy must minimize downtime by using continuous replication. Which of the following actions must the solutions architect perform to successfully convert the schema and support continuous replication? (Select two.)
- Use the AWS Schema Conversion Tool (SCT) to convert the source database schema and database code objects to PostgreSQL-compatible formats.Cevap
- Enable Microsoft Change Data Capture (MS-CDC) on the source SQL Server database and tables to allow AWS Database Migration Service (DMS) to capture ongoing changes.Cevap
- CDeploy AWS Application Migration Service (MGN) to perform block-level replication of the database server to the target Amazon Aurora PostgreSQL cluster.
- DStart the AWS DMS task immediately with CDC enabled without modifying source logging configurations, as AWS DMS reads memory pools directly.
- EUse AWS Resource Access Manager (RAM) to share database storage backup volumes directly with the target Amazon Aurora PostgreSQL cluster.
Cevap
To perform a successful migration, the solutions architect must use the AWS Schema Conversion Tool to convert the source database schema and enable Microsoft Change Data Capture on the source SQL Server database.
The correct options properly address both parts of the requirement: using AWS Schema Conversion Tool (SCT) to translate the schema for a heterogeneous database engine target, and enabling MS-CDC on the source SQL Server database to support continuous replication during the database migration.
Adım Adım Çözüm
Anahtar Kavram
Heterogeneous database migrations with AWS DMS and SCT require schema conversion first, followed by configuring proper source database logging to allow continuous replication (CDC).