SAA-C03 Question 508
Select 2A company is running a MySQL database on Amazon RDS in their production environment. They want to migrate this database to PostgreSQL to take advantage of specific PostgreSQL features. The company requires minimal downtime during the migration process. Which combination of services should they use to achieve this?
- A
AWS Database Migration Service (DMS)
- B
AWS Schema Conversion Tool (SCT)
- C
Amazon RDS Read Replica
- D
Amazon Aurora Global Database
- E
AWS Snowball
Show answer and explanation
Correct answers: A, B
Explanation
To migrate from MySQL to PostgreSQL with minimal downtime, the combination of AWS Database Migration Service (for continuous replication) and AWS Schema Conversion Tool (for schema conversion) is the most appropriate. DMS allows live migration while keeping the source and target databases synchronized, and SCT ensures the database schema is properly converted to be compatible with the target engine.
- A. Correct.
AWS Database Migration Service (DMS) can perform live data replication, including during heterogeneous migrations, minimizing downtime during the migration process.
- B. Correct.
AWS Schema Conversion Tool (SCT) is used to convert the source schema from MySQL to PostgreSQL when performing a heterogeneous database migration.
- C. Incorrect.
Amazon RDS Read Replica is used for scaling read operations in homogeneous database environments, but it does not support schema conversion or cross-engine migrations.
- D. Incorrect.
Amazon Aurora Global Database is designed for global database replication across regions but is not suitable for schema conversion or migrations between MySQL and PostgreSQL.
- E. Incorrect.
AWS Snowball is a physical data transfer service primarily used for transferring large amounts of data to AWS. It is not designed for live database migrations or schema conversion.