AWS Certified Data Engineer – AssociateData Ingestion and TransformationMedium
A healthcare provider needs to migrate a 200 TB on-premises Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime for applications that rely on the database, and data consistency is paramount. The migration involves both schema conversion and continuous data replication. Which AWS service is the MOST appropriate for this migration?
- AAWS Snowball Edge
- BAWS DataSync
- CAWS Glue ETL
- DAWS Database Migration Service (DMS)
Show answer & explanationAnswer & explanation
Correct answer: D. AWS Database Migration Service (DMS)
AWS DMS is specifically designed for migrating databases with minimal downtime and ensuring data consistency, supporting both homogeneous and heterogeneous migrations. It can perform continuous data replication (CDC) and integrates with AWS Schema Conversion Tool (SCT) for schema conversion.
Why the other options are wrong
- A. AWS Snowball Edge is for large-scale offline data transfer, primarily for files or large datasets, not for online database migration with continuous replication.
- B. AWS DataSync is for file and object storage transfer, not for database migration with continuous replication and schema conversion.
- C. AWS Glue ETL is for data integration and transformation, not for live database migration with schema conversion and continuous replication from an operational database.
AWS Database Migration Service (DMS)
A cloud service that helps migrate relational databases, data warehouses, NoSQL databases, and other types of data stores with minimal downtime.
- Supports homogeneous and heterogeneous migrations.
- Enables continuous data replication (CDC).
- Integrates with AWS Schema Conversion Tool (SCT).
Memory trick: DMS moves your database, keeping it live and consistent.