You have been tasked with migrating an on-premises MySQL database to Amazon Aurora PostgreSQL using AWS Database Migration Service (DMS). The stakeholder emphasizes that the source database must…

AWS DMS does not only support full-load migrations; its continuous replication feature is crucial for migrations requiring minimal downtime.

AWS DMS provides robust support for both a one-time full data load and continuous replication (Change Data Capture or CDC) from the source to the target database. This dual capability allows the source MySQL database to remain operational by applying ongoing changes to Aurora PostgreSQL, minimizing downtime for the cutover.

The target Amazon Aurora PostgreSQL instance can typically be accessed for validation and testing during the migration process, even while DMS is actively replicating changes.

While specific version compatibility exists, stating a blanket requirement of MySQL 5.7 or higher is too specific and not the most pertinent point regarding keeping the source operational during migration.

AWS DMS is primarily for data migration; it does not automatically convert complex database schemas (like stored procedures, functions, or specific data types) from MySQL to PostgreSQL. AWS Schema Conversion Tool (SCT) is used for schema conversion.