Examples for Database Migration Solution Playbooks provided by AWS and OCI

Mahmoud Rabie
2 min readSep 26, 2020

Database Migration Solution Playbook is a step-by-step guide that aims to help make database migrations faster and easier and achieve.

In this article, I mention five important database migration playbooks provided by Amazon Web Services (AWS). In addition, I state nine migration solution playbooks provided by Oracle Cloud Infrastructure (OCI).

Amazon Web Services (AWS)

AWS Database Migration Playbooks are a series of guides focused on best practices for creating successful heterogeneous database migration blueprints. AWS provide the following five Migration playbooks and step-by-step guides:

  • Migrate from Microsoft SQL Server to Amazon Aurora MySQL
  • Migrate from Microsoft SQL Server to Amazon Aurora PostgreSQL
  • Migrate from Oracle to Amazon Aurora PostgreSQL
  • Migrate from Oracle to Amazon Aurora MySQL
  • Migrate from Oracle to Amazon Redshift

Reference: AWS Database Migration Service resources

Oracle Cloud Infrastructure (OCI)

Oracle provides the following nine solution playbooks as examples for Cloud Database Migration:

  • Migrate an on-premises database to the cloud with zero downtime
  • Migrate data from on-premises to an autonomous database in the cloud using MV2ADB
  • Migrate a database from on-premises to the cloud with Oracle RMAN
  • Migrate a database to the cloud with the Ansible Database Migration Tool
  • Migrate a Database Cloud Service deployment to a new shape with the ibkup utility
  • Migrate a single-instance database to the cloud
  • Learn about reducing downtime during a database migration
  • Upgrade and migrate a database to the cloud with minimal downtime
  • Learn about migrating custom applications with Oracle databases to Oracle Cloud

Reference: Oracle Architecture Center

--

--

Mahmoud Rabie

Cloud Solution Architect and Technical Consultant who has over 20y experience in analysis, design, development and delivery of on-premise and cloud solutions.