Amazon Web Services

AWS Database Migration Service (DMS):

AWS DMS is a fully managed service that enables you to migrate databases to AWS with minimal downtime. It supports both homogeneous and heterogeneous migrations.

Features:

• Continuous data replication using CDC with minimal impact on source systems.

• Quickly and securely migrate databases to AWS, resilient, self healing

• The source database remains available during the migration

• You must create an EC2 instance to perform the replication tasks

• Schema conversion for heterogeneous migrations.

Supports:

• Homogeneous migrations: ex Oracle to Oracle

• Heterogeneous migrations: ex Microsoft SQL Server to Aurora

Schema Conversion Tool (SCT)

• Convert your Database’s Schema from one engine to another

• Example OLTP: (SQL Server or Oracle) to MySQL, PostgreSQL, Aurora

• Example OLAP: (Teradata or Oracle) to Amazon Redshift

• Prefer compute-intensive instances to optimize data conversions

Note : You do not need to use SCT if you are migrating the same DB engine

Ex: On-Premise PostgreSQL => RDS PostgreSQL

The DB engine is still PostgreSQL (RDS is the platform)