A company wants to move its on-premises Oracle database to an Amazon Aurora PostgreSQL DB cluster. The source database includes 500 GB of data. 900 stored procedures and functions, and application…

AWS DMS primarily focuses on data migration and schema creation for a target database, but it does not automatically convert complex database code objects, stored procedures, or application code during a heterogeneous migration.

AWS DMS is highly effective for migrating large datasets with minimal downtime, including continuous data replication for near zero-downtime cutovers, while the AWS Schema Conversion Tool (AWS SCT) automatically converts database schema objects (like stored procedures and functions) and application code from Oracle to PostgreSQL. SCT also highlights objects requiring manual intervention, addressing the stated requirement for some manual effort, making this the standard best practice for heterogeneous migrations.

AWS Schema Conversion Tool (AWS SCT) is designed for converting schema and code, but it does not perform the actual data migration for large datasets, which would be handled by a service like AWS DMS.

Oracle's dump and PostgreSQL's pg_dump utilities are specific to their respective database types and are not suitable for heterogeneous schema conversion from Oracle to PostgreSQL, nor are they typically the best choice for large, minimal-downtime data migrations across different database engines.