Migrate from EC2 with MSSQL to instance without

Question

I need to migrate an instance with a SQL license to an instance without one to save money on the monthly bill. I've made a copy of the DB to RDS in SQLExpress, and tested with the application successfully. I now need to figure out how to migrate the data to a smaller instance without SQL. Anyone know the best way to achieve this? The basic method of changing instance type fails as it wont let me choose an instance without SQL.

Answer

Hi, you can use AWS Application Migration Service (AWS MGN) for this purpose. Follow the steps and you should achieve your goal. Regarding your inquiry, if you're going to use AWS MGN, you can backup your data (dump file) that resides on your server, compress the data and then you can move forward.

https://docs.aws.amazon.com/es_es/mgn/latest/ug/what-is-application-migration-service.html

Answer

"*Changing your license type from License Included to BYOL will require you to import your your own Windows and SQL Server media through VM Import Export (VMIE) to create Amazon Machine Images (AMIs). You can use these AMIs to launch Windows and SQL Server instances. In addition, when switching from license included to BYOL, you will be required to activate Windows Server using either your own Key Management Service (KMS) activation or Multiple Activation Key (MAK) activation.*"

Refer to [AWS announces a new capability to switch license types for Windows Server and SQL Server applications on Amazon EC2](https://aws.amazon.com/about-aws/whats-new/2021/11/aws-switch-license-windows-sql-server-ec2/)

Migrate from EC2 with MSSQL to instance without

Relevant content