top of page
Jaishree Srinivasan

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)







10 views0 comments

Recent Posts

See All

Comments


bottom of page