Database Migration Service (DMS)

Types of Database Migrations

homogeneous heterogeneous

Heterogeneous Migrations

migration from *different* type of data services requires SCT, but you do not need it if databases are identical *ex. Microsoft SQL Server --> Amazon Aurora*

Homogeneous Migrations

migration from *same* type of database services *ex. Oracle (on-premise) --> Oracle (AWS Cloud)*

Targets

on-premise and EC2 instances databases: Oracle, Microsoft SQL Server, MySQL, MariaDB, PostgreSQL and SAP RDS Redshift DynamoDB S3 Elasticsearch service Kinesis Data Streams DocumentDB

Sources

on-premise and EC2 instances databases: Oracle, Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, SAP, MangoDB and DB2 Azure SQL Database Amazon RDS (including Aurora) Amazon S3

AWS Database Migration Service (Properties)

way of migrating databases can migrate on and off cloud server in the AWS cloud that runs replication software creates tables and associated primary keys, if they do not already exist

You can pre-create the target tables manually, or you can use what?

AWS Schema Conversion Tool (SCT)

DMS Mapping

*AWS DMS:* *Source* Database --> [*SOURCE ENDPOINT*--> *REPLICATION TASK* --> *TARGET ENDPOINT*] --> *Target* Database