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

• SAP ASE version 15.x and 16.x or later (for the latest information, see Using an SAP Database as a Source for AWS DMS)

• PostgreSQL 9.6 or later (for details, see Using a PostgreSQL Database as a Target for AWS DMS)

• Amazon Aurora 1.x or later (for the latest information, see Aurora PostgreSQL-Compatible releases and engine 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

Analyze the migration

Task	Description	Skills 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

Configure the infrastructure

Task	Description	Skills required
Create a virtual private cloud (VPC).		SysAdmin
Create security groups.		SysAdmin
Configure and start the Amazon Aurora cluster.		SysAdmin

Migrate the data

Task	Description	Skills 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

Migrate the application

Task	Description	Skills required
Follow the application migration strategy.		DBA, SysAdmin, App owner

Cut over

Task	Description	Skills required
Switch over the application clients to the new infrastructure.		DBA, SysAdmin, App owner

Close the project

Task	Description	Skills 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

Related resources

References

• AWS Database Migration Service

• Amazon Aurora pricing

• Best practices with Amazon Aurora PostgreSQL-Compatible Edition

Tutorials and videos

• Getting Started with AWS Database Migration Service

• Using an SAP ASE Database as a Source for AWS DMS

• AWS Database Migration Service (video)