Migrating SQL Server Database to MySQL on AWS Cloud

Migrate SQL Server Database to MySQL on AWS Cloud

Prev Question Next Question

Question

Your Organization is planning to move its on-premise databases to the AWS Cloud.

You have been selected to migrate the main production database, and there are some requirements.

The production database should remain active during the migration.

You need to monitor the progress of the migration.

The database is an SQL Server Database.

You need to find an easy way to convert the actual schemas to MySQL schemas.

What services could help to achieve this? (Select two)

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E.

Correct Answers: C &

D.Option A is incorrect.

DataSync is a service mainly used to migrate NFS servers to S3, EFS, Fsx, etc.

It does not support database migrations.

More details here:

https://aws.amazon.com/datasync/faqs/

Option B is incorrect.

AWS Server Migration service is used to migrate on-premises workloads to AWS EC2

It does not support migrations to databases in AWS.

More details:

https://aws.amazon.com/server-migration-service/faqs/

Option C is CORRECT.

AWS Database Migration Service helps you to migrate your On-Premise database to AWS, keeping the On-Premise database fully operational during the migration.

It also converts PL/SQL and SQL Server to MySQL or Postgres schemas with the help of the AWS Schema Conversion Tool included in this service.More details:

https://aws.amazon.com/dms/faqs/

Option D is CORRECT.

AWS Migration Hub is used to track the progress of migrations in AWS.

More details here:

https://aws.amazon.com/migration-hub/

Option E is incorrect.

AWS Server Migration Service Connector is a FreeBSD VM that needs to be installed in the on-premises virtualization environment to work with the Server Migration Service and AWS resources.

More details:

https://aws.amazon.com/server-migration-service/faqs/

The two services that could help achieve the requirements are C. AWS Database Migration Service and D. AWS Migration Hub.

AWS Database Migration Service (DMS) is a fully managed service that allows for database migration to and from various database engines such as SQL Server, MySQL, Oracle, and others. It can be used to migrate data between on-premises databases and AWS, or between different AWS database services. During the migration, the source database remains operational, and changes made to the source database during the migration are continuously replicated to the target database.

To use DMS to convert SQL Server schemas to MySQL schemas, you would first create a replication instance in AWS, which will act as a migration server. You would then create a migration task, specifying the source database endpoint (in this case, the SQL Server database) and the target database endpoint (in this case, the MySQL database). DMS will then use schema conversion tools to convert the SQL Server schema to a MySQL schema, and replicate the data to the target database.

AWS Migration Hub (MH) is a service that provides a central location to track and manage your application migrations across multiple AWS and partner solutions. It helps monitor the progress of the migration, providing visibility into the status of each migration task and identifying any issues that may need to be resolved.

MH integrates with various migration tools and services, including DMS, to provide a centralized view of all migration activities. It can help you assess your migration readiness, plan and execute your migration, and track your progress. By using MH, you can easily track the progress of your database migration task and monitor any issues that may arise during the migration.

Therefore, AWS Database Migration Service and AWS Migration Hub are two services that can be used to migrate an SQL Server database to MySQL while keeping the source database operational during the migration, and to monitor the progress of the migration.