SAP-C02 Question 604
Select 3Your company is migrating an on-premises Oracle database to Amazon Aurora PostgreSQL. The Oracle database contains several stored procedures and custom PL/SQL code. You need to perform the migration with minimal disruption to the application and ensure that the custom code is converted to a format compatible with Aurora PostgreSQL. Which combination of steps should you take to accomplish this migration?
- A
Use AWS Database Migration Service (AWS DMS) to migrate the database schema from Oracle to Amazon Aurora PostgreSQL.
- B
Use AWS Schema Conversion Tool (AWS SCT) to convert the database schema and custom PL/SQL code to PostgreSQL-compatible code.
- C
Manually rewrite the PL/SQL code to be compatible with Aurora PostgreSQL after migrating the data using AWS DMS.
- D
Use AWS DMS to perform a full load of the data from Oracle to Amazon Aurora PostgreSQL, followed by ongoing replication to minimize downtime.
- E
Leverage AWS Schema Conversion Tool (AWS SCT) to assess schema compatibility and provide recommendations before initiating the migration.
Show answer and explanation
Correct answers: B, D, E
Explanation
Migrating an Oracle database to Amazon Aurora PostgreSQL involves multiple steps. AWS DMS is used for data migration and ongoing replication, while AWS SCT is critical for converting the database schema and custom PL/SQL code to PostgreSQL-compatible formats. Additionally, AWS SCT can provide a detailed assessment of schema compatibility and recommendations, which are valuable for planning the migration. Together, these tools minimize manual effort and ensure a streamlined migration process.
- A. Incorrect.
Incorrect: AWS DMS focuses on migrating data and performing ongoing replication but does not handle schema conversion or PL/SQL code transformation.
- B. Correct.
Correct: AWS SCT is specifically designed to convert database schema and custom code (e.g., PL/SQL) to be compatible with the target database, in this case, Amazon Aurora PostgreSQL.
- C. Incorrect.
Incorrect: While manually rewriting code is an option, it is time-consuming and error-prone. AWS SCT automates this process and is the recommended approach.
- D. Correct.
Correct: AWS DMS can perform the actual data migration and ongoing replication to minimize downtime, making it a critical part of the migration process.
- E. Correct.
Correct: AWS SCT provides insights into schema compatibility and recommendations, which are essential for planning and executing a smooth migration.