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)
Comments