Migration from RDS for MySQL to RDS for SQL Server Using AWS DMS

Yes, it is possible to migrate from AWS RDS for MySQL to Amazon RDS for SQL Server using AWS Database Migration Service (AWS DMS).

AWS DMS supports heterogeneous migrations between different database platforms, including from MySQL to SQL Server. While the AWS Schema Conversion Tool (SCT) may not show RDS for SQL Server as a direct target option from MySQL, AWS DMS itself can handle this migration.

AWS DMS can migrate data from a MySQL source to a SQL Server target. This includes both the initial full load of existing data and ongoing replication of changes. AWS DMS supports various editions of SQL Server as targets, including the Amazon RDS editions.

However, it's important to note that AWS DMS primarily focuses on migrating the data itself. It doesn't automatically migrate secondary indexes, sequences, stored procedures, triggers, views, and other schema objects that aren't directly related to data. For these schema objects, you may need to use additional tools or perform manual conversions.

When planning this migration, you'll need to:

1. Set up your source MySQL database and target SQL Server database.
2. Create an AWS DMS replication instance.
3. Define the source (MySQL) and target (SQL Server) database endpoints in AWS DMS.
4. Create and run a migration task in AWS DMS.

Keep in mind that due to differences between MySQL and SQL Server, you may need to make some schema and code adjustments to ensure compatibility. It's recommended to thoroughly test the migration process and validate the data and functionality in the target SQL Server database before finalizing the migration.
Sources
Using a Microsoft SQL Server database as a target for AWS Database Migration Service - AWS Database Migration Service
Migrating data - Migrating Your Databases to Amazon Aurora