MemberJuly 28, 2022 at 7:17 pm
Hi folks! This question has confused me. Why would you convert the database to MySQL? AWS RDS supports SQL Server. My guess is ‘save on operational overhead costs’ implies that using managed MySQL over managed SQL Server would have notable cost savings. Thoughts?
A large company runs its mission-critical Microsoft SQL Server Always On cluster in its on-premises data center servers. The management is planning to migrate its core applications including the database servers to the AWS cloud. The management specifically requested to use AWS managed services whenever possible to save on operational overhead costs. The Solutions Architect must create a heterogeneous database migration strategy to AWS.
Which of the following options is the recommended solution that will meet the above requirements?
Answer: Install the AWS Schema Conversion Tool on the on-premises datacenter to convert the database schema from Microsoft SQL Server to MySQL. Create an Amazon RDS for MySQL instance. Migrate the on-premises database to the RDS instance using AWS Database Migration Service (DMS).
MemberJuly 31, 2022 at 9:15 pm
My thinking is that Mysql(open-source) costs less to scale compared to mssql on RDS. With schema conversion provided an easy way, it makes monetary sense to convert into mysql database.
MemberAugust 14, 2022 at 7:49 pm
Thanks for the feedback.
My guess is ‘save on operational overhead costs’ implies that using managed MySQL over managed SQL Server would have notable cost savings.
>> Yes, the migration to RDS is to satisfy the requirement for lesser operational overhead and lesser cost as there is no licensing fee associated with MySQL compared to MS SQL.
Additionally, the question states “heterogeneous database migration strategy to AWS”, this also implies that they want to change the database solution during the migration. Thus, a combination of SCT (to convert the database) and DMS (to migrate the database) is used as a solution.
Hope this helps.
Let us know if you need further assistance. The Tutorials Dojo team is dedicated to helping you pass your AWS exam!
Kenneth Samonte @ Tutorials Dojo
Log in to reply.