Migrate an on-premises Oracle database to Amazon RDS for MySQL using AWS DMS and AWS SCT - AWS Prescriptive Guidance

Migrate an on-premises Oracle database to Amazon RDS for MySQL using AWS DMS and AWS SCT

R Type: Re-architect

Source: Databases: Relational

Target: Amazon RDS for MySQL

Created by: AWS

Environment: PoC or pilot

Additional technologies: Databases

Workload: Oracle

Summary

This pattern walks you through the migration of an on-premises Oracle database to an Amazon Relational Database Service (Amazon RDS) for MySQL DB instance. It uses AWS Database Migration Service (AWS DMS) to migrate the data, and AWS Schema Conversion Tool (AWS SCT) to convert the source database schema and objects to a format that's compatible with Amazon RDS for MySQL.

Prerequisites and limitations

Prerequisites

  • An active AWS account

  • A source Oracle database in an on-premises data center

Limitations

  • Database size limit: 64 TB

Product versions

Architecture

Source technology stack

  • On-premises Oracle database

Target technology stack

  • Amazon RDS for MySQL DB instance

Data migration architecture

Tools

  • AWS DMS - AWS Database Migration Services (AWS DMS) helps you migrate relational databases, data warehouses, NoSQL databases, and other types of data stores. You can use AWS DMS to migrate your data into the AWS Cloud, between on-premises instances (through an AWS Cloud setup), or between combinations of cloud and on-premises setups.

  • AWS SCT - AWS Schema Conversion Tool (AWS SCT) is used to convert your database schema from one database engine to another. The custom code that the tool converts includes views, stored procedures, and functions. Any code that the tool cannot convert automatically is clearly marked so that you can convert it yourself.

Epics

Task Description Skills required
Validate the source and target database version and engine. DBA
Identify the hardware requirements for the target server instance. DBA, SysAdmin
Identify the storage requirements (storage type and capacity). DBA, SysAdmin
Choose the proper instance type based on capacity, storage features, and network features. DBA, SysAdmin
Identify the network access security requirements for the source and target databases. DBA, SysAdmin
Identify the application migration strategy. DBA, SysAdmin, AppOwner
Task Description Skills required
Create a virtual private cloud (VPC) and subnets. SysAdmin
Create the security groups and network access control lists (ACLs). SysAdmin
Configure and start an Amazon RDS DB instance. DBA, SysAdmin
Task Description Skills required
Migrate the database schema by using AWS SCT. DBA
Migrate data by using AWS DMS. DBA
Task Description Skills required
Use AWS SCT to analyze and convert the SQL code inside the application code. For more information, see https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Converting.App.html. AppOwner
Follow the application migration strategy. DBA, SysAdmin, AppOwner
Task Description Skills required
Switch the application clients over to the new infrastructure. DBA, SysAdmin, AppOwner
Task Description Skills required
Shut down the temporary AWS resources. DBA, SysAdmin
Review and validate the project documents. DBA, SysAdmin
Gather metrics around time to migrate, % of manual vs. tool, cost savings, etc. DBA, SysAdmin
Close out the project and provide feedback.

References

Tutorial and videos