An organization is planning to migrate a self-managed Oracle database running on Amazon EC2 to an Amazon RDS for PostgreSQL DB instance. The migration must involve converting the database schema (including stored procedures) and replicating data with minimal downtime.
Which of the following actions should the organization perform to accomplish this database migration? (Select TWO.)
- Use the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle database schema and stored procedures into PostgreSQL-compatible definitions.Answer
- Use AWS Database Migration Service (AWS DMS) to migrate the data from the source Oracle database to the target Amazon RDS for PostgreSQL DB instance.Answer
- CUse AWS Application Migration Service (AWS MGN) to perform a block-level server migration, which will automatically convert the database engine and code.
- DConfigure an AWS DMS replication task for ongoing Change Data Capture (CDC) without enabling supplemental logging on the source Oracle database.
- EConfigure an Amazon RDS for PostgreSQL read replica directly from the source Oracle database on EC2 to handle the real-time data replication.
Answer
Use the AWS Schema Conversion Tool (AWS SCT) to convert the Oracle database schema and stored procedures, and use AWS Database Migration Service (AWS DMS) to migrate the data.
For a heterogeneous database migration (Oracle to PostgreSQL), two primary steps are required: converting the schema and migrating the data. The AWS Schema Conversion Tool (AWS SCT) converts the database schema, including stored procedures, views, and other database objects. AWS Database Migration Service (AWS DMS) is then used to perform the data migration, supporting both full load and replication (Change Data Capture) to minimize downtime.
Step-by-Step Solution
Key Concept
Heterogeneous database migration using AWS Schema Conversion Tool (AWS SCT) for schema conversion and AWS Database Migration Service (AWS DMS) for data migration.