Migration Architecture - Database Migration Guide
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Migration Architecture

This walkthrough uses Amazon CloudFormation to create a simple network topology for database migration that includes the source database, the replication instance, and the target database in the same VPC. For more information about Amazon CloudFormation, see the Amazon CloudFormation documentation.

We provision the Amazon resources that are required for this Amazon DMS walkthrough through Amazon CloudFormation. These resources include a VPC and Amazon RDS instance for Oracle and an Amazon Redshift cluster. We provision through Amazon CloudFormation because it simplifies the process, so we can concentrate on tasks related to data migration. When you create a stack from the Amazon CloudFormation template, it provisions the following resources:

  • A VPC with CIDR (10.0.0.0/24) with two public subnets in your region, DBSubnet1 at the address 10.0.0.0/26 in Availability Zone (AZ) 1 and DBSubnet2 at the address 10.0.0.64/26, in AZ 12.

  • A DB subnet group that includes DBSubnet1 and DBSubnet2.

  • Oracle RDS Standard Edition Two with these deployment options:

    • License Included

    • Single-AZ setup

    • db.m3.medium or equivalent instance class

    • Port 1521

    • Default option and parameter groups

  • Amazon Redshift cluster with these deployment options:

    • dc1.large

    • Port 5439

    • Default parameter group

  • A security group with ingress access from your computer or 0.0.0.0/0 (access from anywhere) based on the input parameter

We have designed the Amazon CloudFormation template to require few inputs from the user. It provisions the necessary Amazon resources with minimum recommended configurations. However, if you want to change some of the configurations and parameters, such as the VPC CIDR block and Amazon RDS instance types, feel free to update the template.

We use the Amazon Web Services Management Console to provision the Amazon DMS resources, such as the replication instance, endpoints, and tasks. You install client tools such as SQL Workbench/J and the Amazon Schema Conversion Tool (Amazon SCT) on your local computer to connect to the Amazon RDS instances.

Following is an illustration of the migration architecture for this walkthrough.

replication instance