Tools for heterogeneous database migrations - AWS Prescriptive Guidance

Tools for heterogeneous database migrations

The following chart provides a list of tools that you can use to migrate from SQL Server to another database engine.

Migration tool Target database support Used for
AWS WQF

Amazon RDS for MySQL

Amazon RDS for PostgreSQL

Amazon Aurora MySQL

Amazon Aurora PostgreSQL

Pre-migration analysis
AWS SCT

Amazon RDS for MySQL

Amazon RDS for PostgreSQL

Amazon Aurora MySQL

Amazon Aurora PostgreSQL

Schema conversion
AWS DMS

Amazon RDS for MySQL

Amazon RDS for PostgreSQL

Amazon Aurora MySQL

Amazon Aurora PostgreSQL

Data migration

The following subsections provide more information about each tool.

AWS WQF

AWS Workload Qualification Framework (AWS WQF) is used to analyze enterprise databases, code, third-party dependencies, and frameworks for migrating to the AWS Cloud. It assesses and rates the workload for the entire migration, including database and application modifications. WQF can recommend strategies and tools that you can use for your migration, and provide actionable feedback. It can also identify actions for completing a migration to Amazon RDS or Amazon Aurora.

You can use WQF during the planning phase of your migration process to determine what you need to do to migrate your data and applications. WQF reports on the following:

  • Workload assessment, based on complexity, size, and technology used

  • Recommendations on migration strategies

  • Recommendations on migration tools

  • Feedback on what exactly to do

  • Assessment of the effort required, based on team size and member roles

AWS doesn’t currently provide the AWS WQF for downloading. If you need help assessing a migration to AWS with AWS WQF, we recommend opening a support ticket. AWS will engage with you directly to help make the process work for you.

AWS SCT

AWS Schema Conversion Tool (AWS SCT) converts your existing commercial database schemas to an open-source engine or to an AWS Cloud-native database. AWS SCT makes heterogeneous database migrations predictable by automatically converting the source database schema and a majority of the database code objects, including views, stored procedures, and functions, to a format that’s compatible with the target database.

When you convert your database schema from one engine to another, you also need to update the SQL code in your applications to interact with the new database engine instead of the old one. AWS SCT also converts the SQL code in C++, C#, Java or other application code. Any objects that can’t be automatically converted are clearly marked for manual conversion. AWS SCT can also scan your application source code for embedded SQL statements and convert them as part of a database schema conversion project. For more information, see Using Microsoft SQL Server as a source for AWS SCT in the AWS documentation.

AWS DMS

AWS Database Migration Service (AWS DMS) migrates your data rapidly and securely to AWS. During migration, the source database remains fully operational, minimizing application downtime. AWS DMS supports homogenous migrations such as migrating data from one SQL Server database to another. It also supports heterogenous migrations between different database platforms, such as migrating your SQL Server database to an open-source database or to an AWS cloud-native database. AWS DMS manages the complexities of the migration process, including automatically replicating data changes that occur in the source database to the target database. After the database migration is complete, the target database remains synchronized with the source database for as long as you choose, and you can switch over to the target database at a convenient time. For more information, see Using a Microsoft SQL Server database as a source for AWS DMS in the AWS documentation.