Migrate a commercial on-premises database to Aurora.
Identify incompatible types, indexes, and stored procedures while minimizing downtime.
Which service combination is most appropriate?
Use AWS SCT for schema assessment and conversion and AWS DMS for full load plus ongoing CDC.
Detailed explanation
Object lifecycle rules do not transform database definitions or replicate changes.
Object lifecycle rules do not transform database definitions or replicate changes.
A log record does not create target tables or continuous replication.
A log record does not create target tables or continuous replication.
TTL deletes DynamoDB items and is not a database migration mechanism.
TTL deletes DynamoDB items and is not a database migration mechanism.
SCT handles heterogeneous schema conversion while DMS performs full load and change data capture.
SCT handles heterogeneous schema conversion while DMS performs full load and change data capture.
Check official documentation
Compare the following points with the official documentation.
AWS Schema Conversion Tool、AWS Database Migration Service、CDCの公式説明を確認する。
What to confirm
SCTとDMSの役割、CDC移行の検証手順を説明できる。
Key points
- AWS SCT
- AWS DMS
- CDC
- Heterogeneous migration
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Migration validation
Compare counts, checksums, data types, and constraints before cutover.
Cutover planning
Monitor CDC lag and rehearse DNS, write freeze, validation, and rollback steps.