🔷

AWS Schema Conversion Tool (SCT)

  • Converts database schemas between different engines, enabling heterogeneous migrations.
  • Use Cases:
    • OLTP: SQL Server / Oracle → MySQL, PostgreSQL, Aurora
    • OLAP: Teradata / Oracle → Amazon Redshift
  • Notes:
    • Use compute-optimized EC2 instances for faster conversion.
    • Not required for same-engine migrations (e.g., PostgreSQL → PostgreSQL).
  • Integration:
    • Often paired with AWS DMS to migrate both schema and data when engines differ.