An on-premises Oracle database must move to a compatible Aurora PostgreSQL target.
Convert schema differences and continuously replicate changes during the migration to minimize downtime.
Which combination of services is most appropriate?
Use AWS Schema Conversion Tool for schema conversion and AWS DMS for the initial load plus ongoing change data capture.
Detailed explanation
SCT assists with heterogeneous schema conversion, while DMS combines an initial load with change data capture to reduce cutover downtime.
SCT assists with heterogeneous schema conversion, while DMS combines an initial load with change data capture to reduce cutover downtime.
Aurora read replicas are for read scaling within the database family and do not convert Oracle schemas.
Aurora read replicas are for read scaling within the database family and do not convert Oracle schemas.
DNS routing does not transform database schemas or replicate data.
DNS routing does not transform database schemas or replicate data.
S3 Lifecycle manages object transitions and deletion, not database schema conversion.
S3 Lifecycle manages object transitions and deletion, not database schema conversion.
Check official documentation
Compare the following points with the official documentation.
AWS Schema Conversion Tool and AWS Database Migration Serviceの公式説明を確認する。
What to confirm
スキーマ変換とデータ移行・変更複製を別工程として設計できる。
Key points
- AWS SCT
- AWS DMS
- Change data capture
Notes
- Environment:
- Confirm current behavior in the official SAA-C03 guide and AWS service documentation.
Foundation review
Conversion versus movement
SCT handles structure while DMS moves data and changes.
Cutover downtime
Continuous replication reduces the amount of change left for final cutover.