This pattern outlines steps for migrating an on-premises Microsoft SQL Server source database to an Amazon Redshift target database by using AWS Schema Conversion Tool (AWS SCT) data extraction agents. An agent is an external program that is integrated with AWS SCT but performs data transformation elsewhere and interacts with other AWS services on your behalf.   

Prerequisites and limitations

Prerequisites

• A Microsoft SQL Server source database used for the data warehouse workload in an on-premises data center

• An active AWS account

Product versions

• Microsoft SQL Server version 2008 or later. For the latest list of supported versions, see AWS SCT documentation. 

Architecture

technology stackSource  

• An on-premises Microsoft SQL Server database

technology stackTarget  

• Amazon Redshift

Data migration architecture

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