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

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

Created by Prashant Borse (AWS)

R Type: Re-architect

Source: Databases: Relational

Target: PostgreSQL on Amazon EC2

Created by: AWS

Environment: PoC or pilot

Technologies: Databases; Migration

Workload: SAP

AWS services: Amazon EC2

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). 

Prerequisites and limitations

Prerequisites

  • An active AWS account

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

Limitations

  • Database size limit: 64 TB

Product versions

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

  • AWS DMS supports PostgreSQL version 9.4 and later (for 9.x), 10.x, and 11.x. For the latest information about supported versions, see the AWS DMS documentation. We recommend that you use the latest version of AWS DMS for the most comprehensive version and feature support. 

Architecture

Source technology stack

  • An on-premises SAP ASE database 

Target technology stack 

  • A PostgreSQL database on an EC2 instance 

Database migration architecture

Tools

  • AWS DMS - AWS Database Migration Service (AWS DMS) is a web service you can use to migrate data from your database that is on-premises, on an Amazon RDS DB instance, or in a database on an EC2 instance, to a database on an AWS service such as Amazon RDS for SQL Server or an EC2 instance. You can also migrate a database from an AWS service to an on-premises database. You can migrate data between heterogeneous or homogenous database engines.

Epics

TaskDescriptionSkills required
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, App owner
TaskDescriptionSkills required
Create a virtual private cloud (VPC).

SysAdmin
Create security groups.

SysAdmin
Configure and start an EC2 instance.

SysAdmin
TaskDescriptionSkills required
Migrate data using AWS DMS.

DBA
TaskDescriptionSkills required
Follow the application migration strategy.

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

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

DBA, SysAdmin
Review and validate the project documents.

DBA, SysAdmin, App owner
Gather metrics around time to migrate, % of manual vs. tool, cost savings, etc.

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

DBA, SysAdmin, App owner

References

Tutorials and videos