AWS Database Migration Service
Step-by-Step Migration Guide (API Version 2016-01-01)

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

Before you begin, you'll need to download an AWS CloudFormation template. Follow these instructions:

  1. Download the following archive to your computer:

  2. Extract the CloudFormation template (Oracle_Redshift_For_DMSDemo.template) from the archive.

  3. Copy and paste the Oracle_Redshift_For_DMSDemo.template file into your current directory.

Now you need to provision the necessary AWS resources for this walkthrough.

To use AWS CloudFormation to create Amazon RDS resources for this walkthrough

  1. Sign in to the AWS Management Console and open the AWS CloudFormation console at

  2. Choose Create Stack.

  3. On the Select Template page, choose Upload a template to Amazon S3.

  4. Click Choose File, and then choose the Oracle_Redshift_For_DMSDemo.template file that you extracted from the archive.

  5. Choose Next. On the Specify Details page, provide parameter values as shown following.

    For This Parameter Do This

    Stack Name

    Type OracletoRedshiftDWusingDMS.


    Provide a unique name for your database. The name should begin with a letter. The default is ORCL.


    Specify the admin (DBA) user for managing the Oracle instance. The default is oraadmin.


    Provide the password for the admin user. The default is oraadmin123


    Provide any unique name for your database. The name should begin with a letter. The default is test.


    Provide the password for the master user. The default is Redshift#123.


    Specify the IP address in CIDR (x.x.x.x/32) format for your local computer. You can get your IP address from Your RDS instances' security group will allow ingress to this IP address. The default is access from anywhere (, which is not recommended; you should use your IP address for this walkthrough.

                                 AWS Database Migration Service Specify Details page
  6. Choose Next. On the Options page, choose Next.

  7. On the Review page, review the details, and if they are correct choose Create.

                                 AWS Database Migration Service replication instance
  8. AWS can take about 20 minutes or more to create the stack with an Amazon RDS Oracle instance and an Amazon Redshift cluster.

                                 AWS Database Migration Service Create Stack page
  9. After the stack is created, select the OracletoRedshiftDWusingDMS stack, and then choose the Outputs view. Record the JDBC connection strings, OracleJDBCConnectionString and RedshiftJDBCConnectionString, for use later in this walkthrough to connect to the Oracle and Amazon Redshift databases.