How to Migrate Microsoft SQL Server database on EC2 to Amazon Aurora

Posted on October 13, 2022 by Rashmi D | Comments(3)

Assume, an E-commerce application is running on an EC2 instance with the Microsoft SQL Server database. But having the Microsoft SQL Server database on EC2 is an unmanaged solution and with this database management becomes a tedious task for the database administrators and they need a managed solution for smooth operation. Database migration involves multiple complex steps, but two fundamental steps are the conversion of schema and code and the migration of data. In this blog, we discuss Data Migration Service (DMS), Schema Conversion Tool, and steps to convert automated data migration from Microsoft SQL Server to Amazon Aurora (MySQL).

Continue Reading…