AWS Database Migration Service

Home » AWS Cheat Sheets » AWS Migration Services » AWS Database Migration Service

AWS Database Migration Service

Last updated on January 18, 2024

AWS Database Migration Service Cheat Sheet

  • AWS Database Migration Service supports homogeneous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle or Microsoft SQL Server to Amazon Aurora.
  • You can use Database Migration Service for one-time data migration into RDS and EC2-based databases.
  • Tutorials dojo strip
  • You can also continuously replicate your data with high availability (enable multi-AZ) and consolidate databases into a petabyte-scale data warehouse by streaming data to Amazon Redshift and Amazon S3.
  • Continuous replication can be done from your data center to the databases in AWS or the reverse.
  • Replication between on-premises to on-premises databases is not supported.
  • The service provides an end-to-end view of the data replication process, including diagnostic and performance data for each point in the replication pipeline.
  • Supports transaction commit date partitioning in CDC Mode when you select Amazon S3 as a target. You can write data from a single source table to a time-hierarchy folder structure in Amazon S3.
Supported Sources Supported targets
  • Oracle
  • Microsoft SQL Server non-Web and Express editions 
  • MySQL
  • MariaDB
  • PostgreSQL
  • MongoDB
  • SAP Adaptive Server Enterprise (ASE)
  • IBM Db2 for Linux, UNIX, and Windows
  • Azure SQL Database
  • Amazon DocumentDB
  • Amazon S3
  • Oracle
  • Microsoft SQL Server non-Web and Express editions
  • MySQL
  • MariaDB
  • PostgreSQL
  • SAP Adaptive Server Enterprise (ASE)
  • Amazon Aurora with MySQL or PostgreSQL compatibility
  • Amazon Aurora Serverless
  • Amazon Redshift
  • Amazon S3
  • Amazon DynamoDB
  • Amazon Elasticsearch Service
  • Amazon Kinesis Data Streams
  • Amazon DocumentDB (with MongoDB compatibility)
  • Amazon Neptune
  • Apache Kafka

AWS Schema Conversion Tool (SCT)

    • The AWS Schema Conversion Tool makes heterogeneous database migrations predictable by automatically converting the source database schema and a majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target database.
    • SCT can also scan your application source code for embedded SQL statements and convert them as part of a database schema conversion project.
    • Supported migrations

Source Database

Target Database

Microsoft SQL Server

Amazon Aurora with MySQL or PostgreSQL, MariaDB, Microsoft SQL Server, MySQL, PostgreSQL

MySQL

Aurora PostgreSQL, MySQL, PostgreSQL

You can migrate schema and data from MySQL to an Aurora MySQL DB cluster without using AWS SCT.

Oracle Database

Aurora MySQL or PostgreSQL, MariaDB, MySQL, Oracle, PostgreSQL

PostgreSQL

Aurora MySQL, MySQL, PostgreSQL, Aurora PostgreSQL

IBM Db2 LUW

Aurora MySQL, MariaDB, MySQL, PostgreSQL, Aurora PostgreSQL

Sybase ASE

Aurora MySQL, Aurora PostgreSQL, MySQL, PostgreSQL

Oracle Data Warehouse, Microsoft SQL Server, Teradata, IBM Netezza, Greenplum, HPE Vertica

Amazon Redshift

Apache Cassandra

Amazon DynamoDB

 

Basic Schema Copy

    • To quickly migrate a database schema to your target instance you can rely on the Basic Schema Copy feature of AWS Database Migration Service.
    • Basic Schema Copy will automatically create tables and primary keys in the target instance if the target does not already contain tables with the same names.
    • It will not migrate secondary indexes, foreign keys or stored procedures. When you need to use a more customizable schema migration process, use AWS SCT.

AWS Database Migration Service Pricing

    • You only pay for the compute resources used during the migration process and any additional log storage. Each database migration instance includes storage sufficient for swap space, replication logs, and data cache for most replications and inbound data transfer is free.

Note: If you are studying for the AWS Certified Database Specialty exam, we highly recommend that you take our AWS Certified Database – Specialty Practice Exams and read our Database Specialty exam study guide.

AWS Certified Database Specialty Practice Exams

AWS Database Migration Service Cheat Sheet Resources:

https://aws.amazon.com/dms/
https://aws.amazon.com/dms/schema-conversion-tool/
https://aws.amazon.com/dms/faqs/

Tutorials Dojo portal

Be Inspired and Mentored with Cloud Career Journeys!

Tutorials Dojo portal

Enroll Now – Our Azure Certification Exam Reviewers

azure reviewers tutorials dojo

Enroll Now – Our Google Cloud Certification Exam Reviewers

Tutorials Dojo Exam Study Guide eBooks

tutorials dojo study guide eBook

FREE AWS Exam Readiness Digital Courses

Subscribe to our YouTube Channel

Tutorials Dojo YouTube Channel

FREE Intro to Cloud Computing for Beginners

FREE AWS, Azure, GCP Practice Test Samplers

Recent Posts

Written by: Jon Bonso

Jon Bonso is the co-founder of Tutorials Dojo, an EdTech startup and an AWS Digital Training Partner that provides high-quality educational materials in the cloud computing space. He graduated from Mapúa Institute of Technology in 2007 with a bachelor's degree in Information Technology. Jon holds 10 AWS Certifications and is also an active AWS Community Builder since 2020.

AWS, Azure, and GCP Certifications are consistently among the top-paying IT certifications in the world, considering that most companies have now shifted to the cloud. Earn over $150,000 per year with an AWS, Azure, or GCP certification!

Follow us on LinkedIn, YouTube, Facebook, or join our Slack study group. More importantly, answer as many practice exams as you can to help increase your chances of passing your certification exams on your first try!

View Our AWS, Azure, and GCP Exam Reviewers Check out our FREE courses

Our Community

~98%
passing rate
Around 95-98% of our students pass the AWS Certification exams after training with our courses.
200k+
students
Over 200k enrollees choose Tutorials Dojo in preparing for their AWS Certification exams.
~4.8
ratings
Our courses are highly rated by our enrollees from all over the world.

What our students say about us?