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
