A company is migrating business-critical applications from an on-premises data center to AWS. The on-premises environment uses a Microsoft SQL Server Always On cluster. The company wants to move to an AWS-managed database service and requires a heterogeneous migration (SQL Server → MySQL). Which approach satisfies these requirements?
Choose an answer
Tap an option to check your answer.
Correct answer: Run the AWS Schema Conversion Tool to convert the database schema to a format compatible with Amazon RDS for MySQL, then use AWS Database Migration Service (AWS DMS) to migrate the data from the on-premises SQL Server to Amazon RDS for MySQL..
Why this is the answer
The correct approach for a heterogeneous migration from SQL Server to Amazon RDS for MySQL involves using AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS). SCT analyzes the source database schema and converts it to a format compatible with the target database, addressing any incompatibilities. DMS then performs the actual data migration, supporting both full load and continuous replication. Migrating using backup and restore utilities is not feasible for heterogeneous migrations as SQL Server backups cannot be directly restored to MySQL. AWS Snowball Edge and AWS DataSync are data transfer services, not database migration tools, and the integration of SQL Server features like BULK INSERT with S3 is not applicable for migrating to RDS for MySQL.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed