DMS & Migration
12 questionsDatabase Migration Service, CDC replication, schema conversion, and migration patterns.
DMS CDC from RDS to S3
How would you set up AWS DMS to capture changes (CDC) from an RDS PostgreSQL database and deliver them to S3? What format options do you have?
Full Load + CDC Migration Pattern
Explain the difference between full load, CDC only, and full load + CDC in DMS. When would you use each?
DMS Task Settings and Tuning
What are the key DMS task settings you would tune for a high-volume CDC task? How do you optimize for throughput vs. latency?
LOB Handling in DMS
Your DMS migration is running extremely slowly. You discover the source tables have BLOB/CLOB columns. Explain the LOB handling modes and how to fix the performance issue.
Schema Conversion Tool (SCT)
What is the AWS Schema Conversion Tool (SCT)? How does it work with DMS for a heterogeneous database migration (e.g., Oracle to Aurora PostgreSQL)?
DMS vs Debezium
Compare AWS DMS and Debezium for CDC. When would you choose one over the other?
Replication Instance Sizing
How do you size a DMS replication instance? Your CDC task is falling behind — how do you diagnose and fix the issue?
Table Mappings and Filters
How do you use DMS table mappings to select, filter, and transform tables during migration? Give examples of common mapping rules.
DMS Validation
How does DMS data validation work? What additional validation would you implement for a critical database migration?
DMS Serverless
What is DMS Serverless? How does it differ from standard DMS, and when would you use it?
Oracle to Aurora Migration Playbook
Design a migration playbook for moving a 5 TB Oracle database to Aurora PostgreSQL. Include planning, execution, and cutover phases.
Ongoing Replication Patterns
Beyond one-time migrations, how would you use DMS for ongoing data replication to feed a data lake? Design the architecture and discuss operational considerations.