Which solution will meet these requirements?
Migrate the SQL Server databases to Amazon RDS for MySQL by using backup and restore utilities.
Use an AWS Snowball Edge Storage Optimized device to transfer data to Amazon S3. Set up Amazon RDS for MySQL. Use S3 integration with SQL Server features, such as BULK INSERT.
Use the AWS Schema Conversion Tool to translate the database schema to Amazon RDS for MySQL. Then use AWS Database Migration Service (AWS DMS) to migrate the data from on-premises databases to Amazon RDS.
Use AWS DataSync to migrate data over the network between on-premises storage and Amazon S3. Set up Amazon RDS for MySQL. Use S3 integration with SQL Server features, such as BULK INSERT.
Explanations:
Migrating SQL Server databases directly to Amazon RDS for MySQL using backup and restore utilities is not feasible due to compatibility issues between SQL Server and MySQL.
While AWS Snowball Edge can transfer data to S3, this method does not directly facilitate the migration of an SQL Server database to Amazon RDS for MySQL effectively.
This option utilizes the AWS Schema Conversion Tool for schema translation and AWS Database Migration Service (DMS) for data migration, which is a suitable method for heterogeneous migration.
AWS DataSync is not the optimal solution for migrating SQL Server databases to Amazon RDS for MySQL, and it does not address schema conversion or direct database migrati
If I had to guess, I’d say the answer is:
Use the AWS Schema Conversion Tool to translate the database schema to Amazon RDS for MySQL. Then use AWS Database Migration Service (AWS DMS) to migrate the data from on-premises databases to Amazon RDS.