DMS - Database Migration Tool

DMS - Database Migration Service

  • Quickly and securely migrate databases to AWS
  • It is resilient and self healing
  • The source database remains available during migration
  • Supports:
    • Homogeneous migrations, example Oracle to Oracle
    • Heterogeneous migrations, example: Microsoft SQL Server to Aurora
  • Supports continuous data replication using CDC
  • We must create an EC2 instance to perform the replication tasks

DMS Sources and Targets

  • Sources:
    • On-premise and EC2 instance databases: Oracle, MS SQL Server, MySQL, MariaDB, PostgreSQL, MongoDB, SAP, DB2
    • Azure SQL Database
    • Amazon RDS: all including Aurora
    • Amazon S3
  • Targets:
    • On-premise and EC2 instance databases: Oracle, MS SQL Server, MySQL, MariaDB, PostgreSQL, AP
    • Amazon RDS
    • Redshift
    • DynamoDB
    • S3
    • ElasticSearch
    • Kinesis Data Streams
    • DocumentDB

AWS Schema Conversion Tool (SCT)

  • Converts a database schema form one engine to another. Example: OLTP (SQL Server, Oracle) to MySQL, PostgreSQL, Aurora; OLAP (Teradata or Oracle) to Redshift
  • We do not need to use SCT if we are migration from the same DB engine to the same DB engine