Does AWS SCT support RDS SQL Server?

Question

Hi all, I'm wondering if AWS Schema Conversion Tool supports RDS for SQL Server Standard Edition as a source endpoint? The documentation says that it does not so wanted to check if anyone has tried this before? And what is the recommended target database engine to migrate to (RDS PostgreSQL or RDS MySQL) that will have the least amount of code refactoring?

Thanks!

Answer

Are you looking to migrate from SQL Server to PostgreSQL or MySQL?
You can explore [Babelfish for Aurora PostgreSQL](https://aws.amazon.com/rds/aurora/babelfish/).

With Babelfish, Aurora PostgreSQL now understands Microsoft SQL Server's  T-SQL, and supports the same communications protocol, so your apps that were originally written for SQL Server can now work with Aurora with fewer code changes.

The blog [Migrate from SQL Server to Amazon Aurora using Babelfish](https://aws.amazon.com/blogs/database/migrate-from-sql-server-to-amazon-aurora-using-babelfish/) provides an overview of the migration steps.  More information in [documentation](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/babelfish.html)

Documentation [Using Microsoft SQL Server as a source for AWS SCT](https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.SQLServer.html) list RDS SQL Server as one of the possible sources

Answer

RDS SQL Server with standard edition is supported as source for AWS SCT.
You can modernize the db objects using SCT to PostgreSQL. 
Documentation mentions about enterprise edition with respect to permissions to capture enterprise features enabled in source SQL Server.

Does AWS SCT support RDS SQL Server?

相关内容