This pattern describes how to migrate from an on-premises Microsoft SQL Server database running on Microsoft Windows, to Microsoft SQL Server on an Amazon Elastic Compute Cloud (Amazon EC2) Linux instance by using backup and restore utilities.

Prerequisites and limitations

Prerequisites

• An active AWS account

• Amazon EC2 Linux AMI (Amazon Machine Image) with Microsoft SQL Server

• AWS Direct Connect between on-premises Windows and Microsoft SQL Server on the Linux EC2 instance

Architecture

Source technology stack

• On-premises Microsoft SQL Server database

Target technology stack

• Linux EC2 instance with a Microsoft SQL Server database

Database migration architecture

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