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 6: Validate the Schema Conversion
Step 7: Create an AWS DMS Replication Instance
Step 8: Create AWS DMS Source and Target Endpoints
Step 9: Create and Run Your AWS DMS Migration Task
Step 10: Verify That Your Data Migration Completed Successfully
Step 11: Delete Walkthrough Resources

Javascript is disabled or is unavailable in your browser.

To use the Amazon Web Services Documentation, Javascript must be enabled. Please refer to your browser's Help pages for instructions.

Document Conventions

Migration architecture for migrating from Amazon RDS for Oracle to Amazon Redshift

Step 1: Launch the RDS Instances in a VPC by Using the AWS CloudFormation Template