SAP-C02 Question 607
Select 2A company is planning to migrate an on-premises Oracle database to Amazon RDS for PostgreSQL. The database includes custom PL/SQL code, stored procedures, and unique schema designs. The company also wants to minimize downtime during the migration. Which combination of tools should you use to meet these requirements?
- A
AWS Schema Conversion Tool (AWS SCT)
- B
AWS Database Migration Service (AWS DMS)
- C
Amazon RDS Data API
- D
AWS Snowball
- E
AWS Glue
Show answer and explanation
Correct answers: A, B
Explanation
The combination of AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS) is ideal for migrating an Oracle database to Amazon RDS for PostgreSQL. AWS SCT handles the schema and code conversion, while AWS DMS performs data migration with minimal downtime using continuous data replication. Other tools mentioned either do not support the required functionality or are not suited for database migrations.
- A. Correct.
AWS Schema Conversion Tool (AWS SCT) is specifically designed to convert database schemas and custom code, such as PL/SQL, from one database engine (Oracle) to another (PostgreSQL). This tool is essential for this scenario.
- B. Correct.
AWS Database Migration Service (AWS DMS) is the right tool to perform the actual migration of data while allowing for minimal downtime by using ongoing replication.
- C. Incorrect.
Amazon RDS Data API is used to interact with Amazon RDS databases in a serverless manner but is not relevant to schema conversion or data migration.
- D. Incorrect.
AWS Snowball is a physical data transfer service used for large-scale data migrations, but it does not support schema conversion or online data replication.
- E. Incorrect.
AWS Glue is a data integration and ETL service, which is not designed for database migration or schema conversion in this context.