AWS Prescriptive Guidance
Patterns

Migrate from SAP ASE to Amazon RDS for SQL Server using AWS DMS

R Type :RePlatform

source :Databases: Relational

target :Amazon RDS for SQL Server

tags :sap ase, microsoft sql server, amazon rds

Summary

This pattern provides guidance for migrating an SAP Adaptive Server Enterprise (ASE) database to an Amazon Relational Database Service (Amazon RDS) DB instance that's running Microsoft SQL Server. The source database can be located in an on-premises data center or on an Amazon Elastic Compute Cloud (Amazon EC2) instance. The pattern uses AWS Database Migration Service (AWS DMS) to migrate data and (optionally) computer-aided software engineering (CASE) tools to convert the database schema.

Assumptions and Prerequisites

Prerequisites

  • An active AWS account

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

Limitations

  • Database size limit: 16 TB

Architecture

 Source technology stack

  • An SAP ASE database (versions 15.x or 16.x and later) that's on premises or on an Amazon EC2 instance

Target technology stack

  • An Amazon RDS for SQL Server DB instance (SQL Server versions 2008 R2, 2012, 2014, 2016, and 2017 for Express, Web, Standard and Enterprise Editions)

Source and target architecture

From an SAP ASE database on Amazon EC2 to an Amazon RDS for SQL Server DB instance:

From an on-premises SAP ASE database to an Amazon RDS for SQL Server DB instance:

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.

CASE tools - For schema conversions, you can optionally use erwin Data Modeler or SAP PowerDesigner.

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
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
Identify the application migration strategy. DBA, SysAdmin, AppOwner

Configure the infrastructure

Tasks

Title Description Skills Predecessor
Create a virtual private cloud (VPC) and subnets. SysAdmin
Create security groups and network access control lists (ACLs). SysAdmin
Configure and start an Amazon RDS DB instance. SysAdmin

Migrate data - option 1

Tasks

Title Description Skills Predecessor
Migrate the database schema manually or use a CASE tool such as erwin Data Modeler or SAP PowerDesigner. DBA

Migrate data - option 2

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

Tutorial and videos

Contact and help

Pattern Library Support: aws-mpl@amazon.com