Question

A company runs a mission-critical 8 TB Oracle database on-premises supporting a 24/7 e-commerce platform. Leadership wants to eliminate Oracle licensing costs by moving to Amazon Aurora PostgreSQL. The database has hundreds of PL/SQL stored procedures, triggers, and proprietary data types. The business requires that the cutover downtime be kept under 15 minutes, and the migration team needs to validate the converted application logic before go-live. Which approach best meets these requirements?

Accepted Answer

Use AWS Schema Conversion Tool (SCT) to convert the schema and code, then use AWS DMS with full load plus change data capture (CDC) to migrate data continuously until cutover.

Answer

Use AWS DMS alone with a full-load-only task to migrate both schema and data, then manually rewrite stored procedures after cutover.

Answer

Export the Oracle database with Data Pump, copy the dump to Amazon S3 using AWS DataSync, and import it directly into Aurora PostgreSQL.

Answer

Use AWS Application Migration Service (MGN) to replicate the database server as-is into EC2, then use native Oracle-to-PostgreSQL tools inside the instance.