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

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

R Type: Re-architect

Source: Databases: Relational

Target: Amazon RDS for Microsoft SQL Server

Created by: AWS

Environment: PoC or pilot

Technology: Databases

Workload: Oracle

Summary

This pattern provides guidance for migrating an on-premises Oracle database to Amazon Relational Database Service (Amazon RDS) for Microsoft SQL Server using AWS Data Migration Service (AWS DMS) and AWS Schema Conversion Tool (AWS SCT).

Prerequisites and limitations

Prerequisites

Limitations

  • Database size limit: 64 TB

Product versions

Architecture

Source technology stack

  • An on-premises Oracle database

Target technology stack

  • Amazon RDS for Microsoft SQL Server

Data migration architecture

Tools

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). SyasAdmin
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, AppOwner
Gather metrics around time to migrate, % of manual vs. tool, cost savings, etc. DBA, SysAdmin, AppOwner
Close out the project and provide feedback. DBA, SysAdmin, AppOwner

References

Tutorials and videos