Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Migrate an on-premises Vertica database to Amazon Redshift using AWS SCT data extraction agents - AWS Prescriptive Guidance

Migrate an on-premises Vertica database to Amazon Redshift using AWS SCT data extraction agents

Created by Sergey Dmitriev (AWS)

Summary

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

Data migration architecture

Architecture for migrating an on-premises Vertica database to Amazon Redshift.

Tools

  • AWS Schema Conversion Tool (AWS SCT) handles heterogeneous database migrations by automatically converting the source database schema and a majority of the custom code to a format that's compatible with the target database. When the source and target databases are very different from one another, you can use an AWS SCT agent to perform additional data transformation. For more information, see Migrating Data from an On-Premises Data Warehouse to Amazon Redshift in the AWS documentation.

Epics

TaskDescriptionSkills required

Validate the source and target database versions.

DBA

Identify storage requirements (storage type and capacity).

DBA, SysAdmin

Choose the proper instance type (capacity, storage features, network features).

DBA, SysAdmin

Identify the network-access security requirements for the source and target databases.

DBA, SysAdmin

Choose an application migration strategy.

DBA, SysAdmin, App owner

Prepare for migration

TaskDescriptionSkills required

Validate the source and target database versions.

DBA

Identify storage requirements (storage type and capacity).

DBA, SysAdmin

Choose the proper instance type (capacity, storage features, network features).

DBA, SysAdmin

Identify the network-access security requirements for the source and target databases.

DBA, SysAdmin

Choose an application migration strategy.

DBA, SysAdmin, App owner
TaskDescriptionSkills required

Create a virtual private cloud (VPC) and subnets.

SysAdmin

Create security groups.

SysAdmin

Configure and start an Amazon Redshift cluster.

SysAdmin

Configure infrastructure

TaskDescriptionSkills required

Create a virtual private cloud (VPC) and subnets.

SysAdmin

Create security groups.

SysAdmin

Configure and start an Amazon Redshift cluster.

SysAdmin
TaskDescriptionSkills required

Migrate the data using the AWS SCT data extraction agents.

For detailed information on using AWS SCT data extraction agents, see the links in the References and Help section.

DBA

Migrate data

TaskDescriptionSkills required

Migrate the data using the AWS SCT data extraction agents.

For detailed information on using AWS SCT data extraction agents, see the links in the References and Help section.

DBA
TaskDescriptionSkills required

Follow the chosen application migration strategy.

DBA, SysAdmin, App owner

Migrate applications

TaskDescriptionSkills required

Follow the chosen application migration strategy.

DBA, SysAdmin, App owner
TaskDescriptionSkills required

Switch over application clients to the new infrastructure.

DBA, SysAdmin, App owner

Cut over to the target database

TaskDescriptionSkills required

Switch over application clients to the new infrastructure.

DBA, SysAdmin, App owner
TaskDescriptionSkills required

Shut down temporary AWS resources.

DBA, SysAdmin

Review and validate the project documents.

DBA, SysAdmin, App owner

Gather metrics about time to migrate, percentage of manual versus tool tasks, cost savings, etc.

DBA, SysAdmin, App owner

Close the project and provide any feedback.

Close the project

TaskDescriptionSkills required

Shut down temporary AWS resources.

DBA, SysAdmin

Review and validate the project documents.

DBA, SysAdmin, App owner

Gather metrics about time to migrate, percentage of manual versus tool tasks, cost savings, etc.

DBA, SysAdmin, App owner

Close the project and provide any feedback.

Related resources

References

Tutorials and videos

PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.