Basic information
| Field | Content |
|---|---|
| English | AWS Schema Conversion Tool |
| Full name | AWS Schema Conversion Tool (AWS SCT) |
| Chinese | 数据库架构转换工具 |
| Japanese | スキーマ変換ツール |
| Exam frequency | ⭐⭐⭐ |
| Often confused with | DMS |
In one sentence
Converts schemas and code objects between heterogeneous database engines.
Stage summary
- Core role：Converts schemas and code objects between heterogeneous database engines.
- Exam frequency：3 / 5
- Compare with：DMS
Memory hook
AWS Schema Conversion Tool = Converts schemas and code objects between heterogeneous database engines.
Core workflow
- Connect source and target databases and generate an assessment report.
- Convert compatible schemas, views, stored procedures, and application SQL.
- Remediate objects that cannot be converted automatically and apply the target schema.
- Use AWS DMS for full load and CDC data replication.
SCT converts structure and code; DMS moves data. Different database engines are the classic SCT case, and an assessment report does not mean data has moved.