A solutions architect is planning to migrate an on-premises Oracle database to an Amazon Aurora PostgreSQL database. The migration must minimize downtime and convert database code such as stored procedures. Which of the following actions are required to convert the database schema and perform the migration with ongoing replication? (Select TWO.)
- Use the AWS Schema Conversion Tool (SCT) to convert the database schema, stored procedures, and functions to PostgreSQL-compatible formats.Cevap
- Enable supplemental logging on the source Oracle database to allow AWS Database Migration Service (DMS) to read the redo logs for Change Data Capture (CDC).Cevap
- CStart the AWS Database Migration Service (DMS) replication task with Change Data Capture (CDC) enabled without configuring supplemental logging or archiving on the source Oracle database.
- DUse AWS Application Migration Service (MGN) to automatically convert the Oracle database engine to PostgreSQL and replicate the underlying blocks.
- EConfigure AWS Resource Access Manager (RAM) to share the on-premises physical disk storage containing Oracle data files with the target database.
Cevap
Use the AWS Schema Conversion Tool (SCT) to convert the database schema, stored procedures, and functions, and enable supplemental logging on the source Oracle database.
To migrate from Oracle to Aurora PostgreSQL (a heterogeneous migration), the schema and code must be converted using the AWS Schema Conversion Tool (SCT). Furthermore, to perform ongoing replication (Change Data Capture), supplemental logging must be enabled on the source Oracle database so AWS DMS can successfully capture and replicate transaction changes from the redo logs.
Adım Adım Çözüm
Anahtar Kavram
Heterogeneous database migration using AWS SCT and AWS DMS with Change Data Capture.