AWS Data migration: Homogeneous, Heterogenous

The service supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations  between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL.

It also allows you to stream data to Amazon Redshift, Amazon DynamoDB, and Amazon S3 from any of the supported sources, which are Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle Database, SAP ASE, SQL Server, IBM DB2 LUW, and MongoDB.

Features:

•     Simple to use
•     Minimal Downtime
•     Supports Most Widely Used Databases
•     Low Cost
•     Fast and Easy to Set-up
•     Reliable

 The AWS Schema Conversion Tool makes heterogeneous database migrations predictable by automatically converting the source database schema  and a majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target database

Heterogenous Database Migrations
     In heterogeneous database migrations the source and target databases engines are different, like in the case of Oracle to Amazon Aurora, Oracle to PostgreSQL, or Microsoft SQL Server to MySQL migrations.
     heterogeneous migrations a two step process

• First use the AWS Schema Conversion Tool to convert the source schema and code to match that of the target database, and then use the AWS Database Migration Service to migrate data from the source database to the target database.

Database Consolidation: We can use AWS Database Migration Service to consolidate multiple source databases into a single target database.

Continuous Data Replication: You can use AWS Database Migration Service to perform continuous data replication.






References:

1. https://aws.amazon.com/dms/