AWS Prescriptive Guidance
Patterns

Migrate from SAP ASE to PostgreSQL on Amazon EC2 using AWS DMS

R Type :ReHost

source :Databases: Relational

target :PostgreSQL on Amazon EC2

tags :sap, ase, postgresql, database

Summary

This pattern provides guidance for migrating an on-premises SAP Adaptive Server Enterprise (ASE) database to a PostgreSQL database on an Amazon Elastic Compute Cloud (Amazon EC2) instance using AWS Database Migration Service (AWS DMS). 

Assumptions and Prerequisites

Prerequisites

  • An active AWS account

  • An SAP ASE database in an on-premises data center

Limitations

  • Database size limit: 64 TB

Architecture

Source technology stack

  • An on-premises SAP ASE database (version 15.x or 16.x and later)

Target technology stack

  • A PostgreSQL database (version 9.4 and later) on an EC2 instance 

Source and target architecture

Tools Used

AWS DMS - AWS Database Migration Service (AWS DMS) supports several source and target databases. For details, see Sources for Data Migration and Targets for Data Migration in the AWS DMS documentation.

Epics

Plan the migration

Tasks

Title Description Skills Predecessor
Validate the source and target database versions. DBA
Identify the storage requirements (storage type and capacity). DBA, SysAdmin
Identify the network requirements (latency, bandwidth). 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
Determine the backup strategy for the target database. DBA
Determine availability and replication requirements. DBA
Identify the application migration strategy. DBA, SysAdmin, AppOwner

Configure the infrastructure

Tasks

Title Description Skills Predecessor
Create a virtual private cloud (VPC). SysAdmin
Create security groups. SysAdmin
Configure and start an EC2 instance. SysAdmin

Migrate data

Tasks

Title Description Skills Predecessor
Migrate data using AWS DMS. DBA

Migrate the application

Tasks

Title Description Skills Predecessor
Follow the application migration strategy. DBA, SysAdmin, AppOwner

Cut over

Tasks

Title Description Skills Predecessor
Switch the application clients over to the new infrastructure. DBA, SysAdmin, AppOwner

Close the project

Tasks

Title Description Skills Predecessor
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 and Help

References

Tutorials and videos

Contact and help

Pattern Library Support: aws-mpl@amazon.com