This pattern provides guidance for migrating an on-premises Vertica database to an Amazon Redshift cluster 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

• An active AWS account

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

• An Amazon Redshift target cluster

Product versions

• Vertica version 7.2.2 and later. For the latest list of supported versions, see the AWS SCT documentation.

Architecture

Source technology stack

• An on-premises Vertica database 

Target technology stack

• An Amazon Redshift cluster

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