Step-by-step Amazon RDS for Oracle to Amazon Redshift migration walkthrough
In the following sections, you can find step-by-step instructions for migrating an Amazon RDS for Oracle database to Amazon Redshift. These steps assume that you have already prepared your source database as described in preceding sections.
Topics
Step 1: Launch the RDS Instances in a VPC by Using the AWS CloudFormation Template
Step 2: Install the SQL Tools and AWS Schema Conversion Tool on Your Local Computer
Step 3: Test Connectivity to the Oracle DB Instance and Create the Sample Schema
Step 4: Test the Connectivity to the Amazon Redshift Database
Step 5: Use AWS SCT to Convert the Oracle Schema to Amazon Redshift
Step 10: Verify That Your Data Migration Completed Successfully