Menu
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

First, 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 https://console.aws.amazon.com/cloudformation.

  2. Choose Create stack.

  3. On the Select Template page, choose Specify an Amazon S3 template URL and paste the following URL into the adjacent text box:

    https://dms-sbs.s3.amazonaws.com/Oracle_Aurora_RDS_For_DMSDemo.template

    
                                 AWS Database Migration Service replication instance
  4. Choose Next. On the Specify Details page, provide parameter values as shown following.

    For This Parameter Do This

    Stack Name

    Type DMSdemo.

    OracleDBName

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

    OracleDBUsername

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

    OracleDBPassword

    Provide the password for the admin user.

    AuroraDBUsername

    Specify the admin (DBA) user for managing the Aurora MySQL instance. The default is auradmin.

    AuroraDBPassword

    Provide the password for the admin user.

    ClientIP

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

    
                                 AWS Database Migration Service Specify Details page
  5. Choose Next. On the Options page, shown following, choose Next.

    
                                 AWS Database Migration Service Options page
  6. On the Review page, review the details, and if they are correct choose Create Stack. You can get the estimated cost of running this CloudFormation template by choosing Cost.

    
                                 AWS Database Migration Service replication instance
  7. AWS can take about 20 minutes or more to create the stack with Amazon RDS Oracle and Amazon Aurora MySQL instances.

    
                                 AWS Database Migration Service Create Stack page
  8. After the stack is created, choose Stack, select the DMSdemo stack, and then choose Outputs. Record the JDBC connection strings, OracleJDBCConnectionString and AuroraJDBCConnectionString, for use later in this walkthrough to connect to the Oracle and Aurora MySQL DB instances.

    
                                 AWS Database Migration Service replication instance

Note

Oracle 12c SE Two License version 12.1.0.2.v4 is available in all regions. However, Amazon Aurora MySQL is not available in all regions. Amazon Aurora MySQL is currently available in US East (N. Virginia), US West (Oregon), EU (Ireland), Asia Pacific (Tokyo), Asia Pacific (Mumbai), Asia Pacific (Sydney), and Asia Pacific (Seoul). If you try to create a stack in a region where Aurora MySQL is not available, creation fails with the error Invalid DB Engine for AuroraCluster.