In one sentence
DMS moves and replicates database data, while AWS SCT converts schemas and code for heterogeneous migrations.
Key points
- DMS supports full load and change data capture to reduce downtime.
- SCT analyzes source schemas and converts compatible database objects and embedded SQL where possible.
- Homogeneous migrations may need DMS without schema conversion.
| Example | Type | Combination |
|---|---|---|
| MySQL → RDS for MySQL | Homogeneous | DMS |
| Oracle → RDS for Oracle | Homogeneous | DMS |
| Oracle → Aurora PostgreSQL | Heterogeneous | SCT + DMS |
| SQL Server → Aurora MySQL | Heterogeneous | SCT + DMS |
Exam takeaway
Heterogeneous migrations often use SCT first and DMS for the actual data transfer.