DMS migration

[Ocean]

For the below question- the correct answer says start a task with CDC and I believe it should be Full load + CDC. please clarify

Q: An organization is challenged in attempting to migrate one of its systems into its AWS account because it can only afford very little to no downtime during the cutover process. As part of the migration process, the Manager hired a database specialist to migrate the data from a 30GB Microsoft SQL Server 2017 Enterprise Edition server from the data center to a new Amazon Aurora MySQL DB cluster with the latest version. The Network Specialist confirmed that a connection exists between the source data center and the target Amazon Virtual Private Cloud via AWS Direct Connect.

What is the most cost-effective way to achieve these requirements?

correct answer: Convert the schema using the AWS Schema Conversion Tool (AWS SCT) and validate the tables in the target MySQL database. Create a replication instance from the AWS Database Migration Service (AWS DMS) console and start a task with the Change Data Capture option to migrate the data. Once the application server points to the target database, stop the replication task.

other options:

*Use Microsoft SQL Server Import and Export Wizard to dump all the tables from the SQL Server databases and transfer the dumps into an Amazon S3 bucket inside the target VPC. Use AWS Glue to run DDL transformations and adjust the schema definitions accordingly. Load the data from the S3 bucket to the MySQL database

*Run a full SQL Server database backup on all databases using the backup database command. Order an AWS Snowball Edge Storage Optimized appliance and copy the backups to the device. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to the database

*Use the AWS Application Migration Service to import the Microsoft SQL Server virtual machine image as an Amazon EC2 instance. Use the SQL Server bcp utility to migrate the database data from Amazon EC2 to the Aurora MySQL DB cluster

[Neil-TutorialsDojo]

Hi Ocean,

Thank you for bringing this up.
In creating a replication instance from the AWS Database Migration Service (DMS) console you can either used CDC only or the combination of both Full load and CDC. A a full load is generally recommended first before enabling CDC when migrating large datasets for better performance and accuracy. But it is also possible to migrate data using CDC-only replication with AWS Database Migration Service (DMS) but may take longer to initially populate the target.
Thank you again for your feedback. We will do the necessary update to make this question more accurate.

Regards,
Neil @ Tutorials Dojo