Schema Conversion

  1. This section is only apply for Amazon Aurora targets. If you are using another target, you can skip to section 3.1.2 \
  2. Several pictures are taken from the Microsoft SQL to Aurora (PostgreSQL) schema conversion. However, different sources and targets employs similar processes. Thus, this guide should also apply for them.

This section demonstrates how to use the AWS Schema Conversion Tool for schema conversion from Microsoft SQL Server or Oracle to Amazon Aurora (MySQL or PostGreSQL). Additionally, you will observe how AWS SCT helps you spot the differences between the two dialects; and, provides you with tips about how you can modify procedural code when needed to successfully migrate all database objects.

Convert MS SQL to Aurora MySQL