Migrate an SAP ASE database to Aurora MySQL using AWS DMS - AWS Prescriptive Guidance

Migrate an SAP ASE database to Aurora MySQL using AWS DMS

Created by Sergey Dmitriev (AWS)

R Type: Re-architect

Source: Databases: Relational

Target: Amazon Aurora MySQL

Created by: AWS

Environment: PoC or pilot

Technologies: Databases; Migration

Workload: SAP

AWS services: Amazon Aurora

Summary

This pattern provides guidance for migrating SAP Adaptive Server Enterprise (ASE) databases to Amazon Aurora MySQL-Compatible Edition DB instances using AWS Database Migration Service (AWS DMS). The pattern applies to SAP ASE source databases in an on-premises data center or on an Amazon Elastic Compute Cloud (Amazon EC2) instance.  

Prerequisites and limitations

Prerequisites

  • An active AWS account

  • An SAP ASE source database in an on-premises data center or on an EC2 instance

Limitations

  • Database size must be less than 64 TB

Product versions

Architecture

Source technology stack

  • SAP ASE database (on premises or on an EC2 instance)

Target technology stack

  • Aurora MySQL-Compatible DB instance 

Data migration architecture

From an SAP ASE database on Amazon EC2 to an Aurora MySQL-Compatible DB instance:

From an on-premises SAP ASE database to an Aurora MySQL-Compatible DB instance:    

Tools

  • AWS DMS - AWS Database Migration Service (AWS DMS) supports several different source and target databases. For details, see Sources for Data Migration and Targets for Data Migration. We recommend that you use the latest version of AWS DMS for the most comprehensive version and feature support.

Epics

TaskDescriptionSkills required
Validate the source and target database versions.

DBA
Identify the storage requirements (storage type and capacity).

DBA, SysAdmin
Choose the proper instance type (capacity, storage features, network features).

DBA, SysAdmin
Identify the network access security requirements for the source and target databases.

DBA, SysAdmin
Choose an application migration strategy.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Create a virtual private cloud (VPC).

SysAdmin
Create security groups.

A security group acts as a virtual firewall for your instance to control inbound and outbound traffic. In AWS DMS, if you use your own security group, egress must, at a minimum, be permitted to the source and target endpoints on the respective database ports.

SysAdmin
Configure and start an Aurora MySQL-Compatible DB instance.SysAdmin
TaskDescriptionSkills required
Migrate data using AWS DMS.

We recommend that you use the latest version of AWS DMS for the most comprehensive version and feature support.

DBA
TaskDescriptionSkills required
Follow the chosen application migration strategy.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Switch over application clients to the new infrastructure.

DBA, SysAdmin, App owner
TaskDescriptionSkills required
Shut down temporary AWS resources.

DBA, SysAdmin
Review and validate the project documents.

DBA, SysAdmin, App owner
Gather metrics about time to migrate, percentage of manual versus tool tasks, cost savings, etc.

DBA, SysAdmin, App owner
Close the project and provide any feedback.

DBA, SysAdmin, App owner

Related resources

References

Tutorials and videos