This pattern describes how to migrate an on-premises Microsoft SQL Server database to Microsoft SQL Server on an Amazon Elastic Compute Cloud (Amazon EC2) instance. It covers two options for migration: using AWS Database Migration Service (AWS DMS) or using native Microsoft SQL Server tools such as backup and restore, Copy Database Wizard, or copy and attach database.

Prerequisites and limitations

Prerequisites

• An active AWS account

• An operating system supported by Amazon EC2 (for a complete list of supported operating system versions, see Amazon EC2 FAQs)

• A Microsoft SQL Server source database in an on-premises data center

Product versions

• For on-premises and Amazon EC2 instance databases, AWS DMS supports:

  • SQL Server versions 2005, 2008, 2008R2, 2012, 2014, 2016, 2017, and 2019

  • Enterprise, Standard, Workgroup, Developer, and Web editions

• For the latest list of supported versions, see Using a Microsoft SQL Server Database as a Target for AWS DMS.  

Architecture

Source technology stack

• On-premises Microsoft SQL Server database

Target technology stack

• Microsoft SQL Server database on an EC2 instance

Target architecture

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-on-premises-microsoft-sql-server-database-to-amazon-ec2.html?did=pg_card&trk=pg_card