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

Migrate an SAP ASE database to Aurora PostgreSQL using AWS DMS

Created by Sergey Dmitriev (AWS)

R Type: Re-architect

Source: Databases: Relational

Target: Amazon Aurora PostgreSQL

Created by: AWS

Environment: PoC or pilot

Technologies: Databases; Migration

Workload: SAP

AWS services: Amazon Aurora

Summary

This pattern describes how to migrate an SAP Adaptive Server Enterprise (ASE) database to an Amazon Aurora PostgreSQL-Compatible Edition instance by 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 database in an on-premises data center or on an EC2 instance

Limitations

  • The source database 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 PostgreSQL-Compatible DB instance

Data migration architecture

From an SAP ASE database on Amazon EC2 to Aurora PostgreSQL-Compatible

From an on-premises SAP ASE database to Aurora PostgreSQL-Compatible

Tools

  • AWS DMS - AWS Data Migration Service (AWS DMS) supports several different source and target databases. For more information, 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. 

  • An optional, third-party CASE (computer-aided software engineering) tool.

Epics

TaskDescriptionSkills required
Validate the source and target database versions.

DBA
Identify the storage requirements for the storage type and capacity.

DBA, SysAdmin
Choose the proper instance type, 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, App owner
TaskDescriptionSkills required
Create a virtual private cloud (VPC).

SysAdmin
Create security groups.

SysAdmin
Configure and start the Amazon Aurora cluster.

SysAdmin
TaskDescriptionSkills required
Migrate the data by 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 application migration strategy.

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

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

DBA, SysAdmin
Validate and review the project documents.

DBA, SysAdmin, App owner
Gather metrics around time to migrate, percent of manual versus tool cost savings, and so on.

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

DBA, SysAdmin, App owner

References

Tutorials and videos