A company is planning to migrate its business-critical applications from an on-premises data center to AWS. The company has an on-premises installation of a Microsoft SQL Server Always On cluster. The

Question

Options

• AMigrate the SQL Server databases to Amazon RDS for MySQL by using backup and restore
• BUse an AWS Snowball Edge Storage Optimized device to transfer data to Amazon S3. Set up
• CUse the AWS Schema Conversion Tool to translate the database schema to Amazon RDS for
• DUse AWS DataSync to migrate data over the network between on-premises storage and Amazon

• A
  10% (3)
• B
  3% (1)
• C
  84% (26)
• D
  3% (1)

Explanation

AWS Schema Conversion Tool (SCT) can automatically convert the database schema from Microsoft SQL Server to Amazon RDS for MySQL. This allows for a smooth transition of the database schema without any manual intervention. AWS DMS can then be used to migrate the data from the on-premises databases to the newly created Amazon RDS for MySQL instance. This service can perform a one-time migration of the data or can set up ongoing replication of data changes to keep the on-premises and AWS databases in sync. https://aws.amazon.com/dms/schema-conversion-tool/

No community discussion yet for this question.