Migrating an Oracle database to Aurora PostgreSQL — a heterogeneous engine change. Which tool converts the schema (tables, views, stored procedures) before DMS moves the data?
A.AWS DMS alone — it auto-converts schemas
DMS migrates data; dialect/schema conversion isn't its job.
B.AWS Schema Conversion Tool (SCT)
Correct. SCT converts heterogeneous schemas.
C.AWS DataSync
DataSync moves files/objects, not database schemas.
D.Manual SQL export and rewrite
Manual conversion is error-prone and slow — SCT exists for this.
Why this answer
SCT translates schemas between database engines (and warehouses) — required for heterogeneous migrations. DMS moves data and can create basic tables, but doesn't convert procedures/views/dialect-specific features. Homogeneous (e.g., MySQL→Aurora MySQL) doesn't need SCT.
Correct answer: B · Last reviewed 2026-11-03
Official AWS references
Practice this interactively
Answer without seeing the solution first in the Migration & Modernization practice session.
Practice Migration & Modernization