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


The following prerequisites are also required to complete this walkthrough:

  • Familiarity with Amazon RDS, the applicable database technologies, and SQL.

  • The custom scripts that include creating the tables to be migrated and SQL queries for confirming the migration, as listed following:

    • Oracle-HR-Schema-Build.sql—SQL statements to build the HR schema.

    • Oracle_Aurora_For_DMSDemo.template—an AWS CloudFormation template.

    These scripts are available at the following link:

    Each step in the walkthrough also contains a link to download the file involved or includes the exact query in the step.

  • An AWS account with AWS Identity and Access Management (IAM) credentials that allow you to launch Amazon Relational Database Service (Amazon RDS) and AWS Database Migration Service (AWS DMS) instances in your AWS Region. For information about IAM credentials, see Creating an IAM User.

  • Basic knowledge of the Amazon Virtual Private Cloud (Amazon VPC) service and of security groups. For information about using Amazon VPC with Amazon RDS, see Virtual Private Clouds (VPCs) and Amazon RDS. For information about Amazon RDS security groups, see Amazon RDS Security Groups.

  • An understanding of the supported features and limitations of AWS DMS. For information about AWS DMS, see What Is AWS Database Migration Service? .

  • Knowledge of the supported data type conversion options for Oracle and Amazon Aurora MySQL. For information about data types for Oracle as a source, see Using an Oracle Database as a Source for AWS Database Migration Service . For information about data types for Amazon Aurora MySQL as a target, see Using a MySQL-Compatible Database as a Target for AWS Database Migration Service .

For more information on AWS DMS, see the AWS DMS documentation.