AWS Schema Conversion Tool
#226 · Level 4 · Operations and specialized areas · Migration and transferConcept
Section titled “Concept”AWS Schema Conversion Tool converts the structure (tables, procedures) of one type of database into another type of database. Schema means the structure of a database — tables, views, stored procedures, functions and so on. It is a desktop application that analyzes the old database and gives a conversion report. Anything that cannot be converted automatically is marked in the report, so it can be fixed by hand. SCT changes the structure, while the actual data is usually moved by DMS.
Simple example
Section titled “Simple example”Translating a book from one language into another — not just the words, but the sentence structure also has to change.
Why it’s needed
Section titled “Why it’s needed”To go from Oracle to PostgreSQL, you have to change not just the data but also the database’s code.
Where it’s used
Section titled “Where it’s used”Moving from Oracle or SQL Server to Aurora PostgreSQL/MySQL. (This work is now also available in DMS Schema Conversion.)
Azure equivalent
Section titled “Azure equivalent”SQL Server Migration Assistant (SSMA)
Learn more
Section titled “Learn more”For details and the latest information, see the official documentation: