Migrate an on-premises SAP ASE database to Amazon EC2 - AWS Prescriptive Guidance

Migrate an on-premises SAP ASE database to Amazon EC2

Created by Sergey Dmitriev (AWS)

R Type: Rehost

Source: Databases: Relational

Target: SAP Adaptive Server Enterprise on Amazon EC2

Created by: AWS

Environment: PoC or pilot

Technologies: Databases; Migration

Workload: SAP

AWS services: Amazon EC2

Summary

This pattern describes how to migrate an SAP Adaptive Server Enterprise (ASE) database from an on-premises host to an Amazon Elastic Compute Cloud (Amazon EC2) instance. The pattern covers the use of AWS Database Migration Service (AWS DMS) or SAP ASE native tools such as ASE Cockpit, Sybase Central for ASE, and DBA Cockpit for migration.

Prerequisites and limitations

Prerequisites

  • An active AWS account

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

Limitations

  • The source database must be less than 64 TB

Product versions

  • SAP ASE version 15.x and 16.x or later

Architecture

Source technology stack

  • On-premises SAP ASE database

Target technology stack

  • SAP ASE database on an EC2 instance

Database migration architecture

Using AWS DMS:

Using native SAP ASE tools:

Tools

Epics

TaskDescriptionSkills required
Validate the source and target database versions.DBA
Identify the target OS version.DBA, SysAdmin
Identify the hardware requirements for the target server instance based on the SAP ASE compatibility list and capacity requirements.DBA, SysAdmin
Identify the requirements for the storage type and capacity.DBA, SysAdmin
Identify the network requirements including latency and bandwidth.DBA, SysAdmin
Choose the proper instance type, capacity, storage features, and network features.DBA, SysAdmin
Identify the network and host access security requirements for the source and target databases.DBA, SysAdmin
Identify a list of operating system users required for the SAP ASE software installation.DBA, SysAdmin
Determine the backup strategy.DBA
Determine the availability requirements.DBA
Identify the application migration and switchover strategy.DBA, SysAdmin, App owner
TaskDescriptionSkills required
Create a virtual private cloud (VPC) and subnets.SysAdmin
Create security groups and the network access control list (ACL).SysAdmin
Configure and start the EC2 instance.SysAdmin
TaskDescriptionSkills required
Create the OS users and groups required for SAP ASE software to work.DBA, SysAdmin
Download the required version of SAP ASE software.DBA, SysAdmin
Install the SAP ASE database, backup server software, and replication server software on the EC2 instance and then configure the server.DBA, SysAdmin
TaskDescriptionSkills required
Migrate the database objects and data by using native SAP ASE tools or third-party tools.

See the documentation for the SAP ASE or third-party tools. These include ASE Cockpit, Sybase Central for ASE, and DBA Cockpit.

DBA
TaskDescriptionSkills required
Migrate the data by using AWS DMS.DBA
TaskDescriptionSkills required
Follow the application migration strategy.DBA, SysAdmin, App owner
TaskDescriptionSkills required
Follow the application cutover or switchover strategy.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