This pattern provides guidance for migrating an on-premises Microsoft SQL Server database to Amazon Redshift by using AWS Data Migration Service (AWS DMS).

Prerequisites and limitations

Prerequisites

• An active AWS account

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

• Completed prerequisites for using an Amazon Redshift database as a target for AWS DMS, as discussed in the AWS DMS documentation

Product versions

• SQL Server 2005-2019, Enterprise, Standard, Workgroup, Developer, and Web editions. For the latest list of supported versions, see Using a Microsoft SQL Server Database as a Source for AWS DMS in the AWS documentation.

Architecture

Source technology stack

• An on-premises Microsoft SQL Server database 

Target technology stack

• Amazon Redshift

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