AWS Database Migration Service (AWS DMS)
Cloud service · AWS · Updated

AWS Database Migration Service (AWS DMS)

In short

AWS Database Migration Service (AWS DMS) is a managed migration and replication service for moving databases and analytics workloads to AWS with minimal downtime. At least one endpoint must be on an AWS service; replication between two on-premises databases is not supported.

Cloud Services Hub →

8 key features of AWS Database Migration Service (AWS DMS)

AWS Database Migration Service (AWS DMS) supports heterogeneous database migrations with minimal downtime, providing continuous data replication, secure migration, easy management, robust monitoring, and a cost-effective, pay-as-you-go pricing model.

01
Support for Heterogeneous Migrations

AWS DMS enables the migration of databases from one type of database platform to another, supporting a wide range of source and target databases including Oracle, MySQL, PostgreSQL, Microsoft SQL Server, and Amazon Aurora.

02
Continuous Data Replication

With AWS DMS, you can replicate data continuously with high availability, enabling minimal downtime for applications during migration and ensuring your data is up-to-date.

03
Minimal Downtime

DMS is designed to ensure that database migrations and replications result in minimal downtime, allowing applications to remain operational and users to access data during the migration process.

04
Secure Data Migration

AWS DMS ensures the security of your data during migration by using SSL encryption for data in transit and enabling encryption at rest for the replicated data in AWS.

05
Easy to Use

The service provides a simple web interface to create, manage, and monitor your database migration tasks, reducing the complexity of migrating databases.

06
Monitoring and Notifications

AWS DMS offers robust monitoring tools and notifications, allowing you to track the progress of your migrations and be alerted to any issues in real-time.

07
Cost-Effective

AWS DMS is a cost-efficient solution for database migration, offering a pay-as-you-go pricing model that helps minimize your migration expenses.

08
Task Data Validation

Data validation can be enabled on a replication task to check that outdated information is not transferred to the target endpoint.

Where AWS Database Migration Service (AWS DMS) is used

AWS Database Migration Service (DMS) facilitates a variety of database migrations including moving legacy systems to AWS, homogeneous and heterogeneous migrations, continuous data replication for disaster recovery, database consolidation for cost saving, and data warehouse migrations to Amazon Redshift.

  1. 01
    Migrating Legacy Databases to AWS

    AWS Database Migration Service is ideal for migrating legacy databases residing on-premises or in a different cloud provider to AWS-supported databases. This process includes the migration from common databases like Oracle, SQL Server, and MySQL to AWS services such as Amazon RDS, Amazon Aurora, or Amazon DynamoDB. DMS simplifies the migration process, reduces downtime, and ensures that data is securely transferred over the AWS network.

  2. 02
    Homogeneous Database Migrations

    DMS enables the seamless migration of databases while retaining the same database engine. For instance, users can migrate from an on-premises MySQL database to an Amazon RDS MySQL instance. DMS manages schema conversion (if necessary) and data replication while minimizing downtime, making it efficient for homogeneous migrations.

  3. 03
    Heterogeneous Database Migrations

    When migrating between different database engines, such as from Oracle to Amazon Aurora, AWS DMS facilitates the conversion of the source database schema and code to be compatible with the target database. This capability is critical for organizations looking to adopt more cost-effective, scalable, or performance-optimized database solutions within AWS.

  4. 04
    Continuous Data Replication

    AWS DMS provides ongoing replication services that allow organizations to replicate data continuously between databases, which is crucial for disaster recovery plans, cross-region database synchronization, or maintaining up-to-date read replicas. DMS's robust and fault-tolerant architecture ensures that data is replicated in real-time with minimal latency.

  5. 05
    Database Consolidation for Cost Saving

    By migrating multiple smaller databases into a single, larger database on AWS, companies can reduce operational complexities and costs. AWS DMS assists in consolidating databases from various sources into Amazon RDS or Amazon Redshift, enabling efficient database management and potentially lowering the total cost of ownership.

  6. 06
    Data Warehouse Migration

    AWS DMS enables the migration of existing data warehouses to Amazon Redshift, allowing organizations to leverage the power of the cloud for analytics. This migration can involve the transfer of large volumes of data and transforming the existing schema to fit Redshift's columnar data store, which DMS streamlines to accelerate the move towards a more scalable, cost-effective data warehousing solution.

How AWS Database Migration Service (AWS DMS) is priced

AWS DMS pricing involves on-demand instance hours based on size and region, with additional charges for data transfer outside of AWS regions or to the internet, and free data loading to Amazon RDS within the same region.

On-Demand Instances

Charged per hour of compute capacity consumed, varying by instance size and region, with no upfront commitments.

Data Transfer

All data transfer into AWS DMS is free, as is transfer between DMS and Amazon RDS or Amazon EC2 databases in the same Availability Zone. Standard AWS data transfer rates apply for migrations to a target in a different Availability Zone, Region, or outside AWS.

Serverless

Charged hourly for capacity used, measured in DMS capacity units (DCUs), with each DCU representing 2 GB of RAM. Single-AZ and Multi-AZ deployment options are available.

Database Savings Plans

Offers savings on eligible DMS usage in exchange for a commitment to a specified amount of usage, measured in dollars per hour, over a one-year term.

Homogeneous Data Migrations

Charged by the hour only for the duration of the migration, without replication instances to provision.

Additional Storage

Storage added beyond the capacity included with replication instances is billed per GB-month, with separate Single-AZ and Multi-AZ rates.

T3 CPU Credits

T3 replication instances run in unlimited mode and incur CPU-credit charges when average CPU utilization over a rolling 24-hour period exceeds the instance baseline. Credits cost $0.075 per vCPU-hour across all T3 sizes and AWS Regions.

Public IPv4 Addresses

Standard public IPv4 address charges apply to associated resources launched in an Amazon VPC.

Schema Conversion

DMS Schema Conversion is free to use; only the Amazon S3 storage it uses is charged.

Zero-ETL Integrations for Self-Managed Databases

Zero-ETL integrations from self-managed databases to Amazon Redshift incur export costs to seed and resynchronize the warehouse, per-GB CDC data transfer charges for ongoing changes, and applicable I/O, storage, and Amazon Redshift compute charges.

AWS Free Tier

For signups before July 15, 2025, the legacy offer provides 750 monthly hours of Single-AZ dms.t3.micro usage for one year and 50 GB of included SSD storage. For signups after July 15, 2025, Free and Paid Plans offer $100 in credits plus up to $100 more for activating foundational services; credits are valid for up to twelve months, and continued use after exhausting credits requires a Paid Plan.

Services AWS Database Migration Service (AWS DMS) works with

Amazon RDSAmazon RDS

AWS DMS can migrate data from and to Amazon RDS databases, enabling easier management of relational database migration.

Amazon AuroraAmazon Aurora

Supports seamless data migration to Amazon Aurora, AWS's fully managed relational database engine that is compatible with MySQL and PostgreSQL.

Amazon RedshiftAmazon Redshift

Facilitates data migration to Amazon Redshift, which is AWS’s data warehousing service, helping users to scale and analyze all their data.

Amazon DynamoDBAmazon DynamoDB

Supports migration to Amazon DynamoDB, a fully managed NoSQL database service designed for fast and flexible performance.

Amazon S3Amazon S3

Enables data migration to Amazon S3, a scalable object storage service, useful for data lakes and cost-effective storage.

AWS GlueAWS Glue

Integrates with AWS Glue to catalog and move data, enabling easier data transformation and loading into AWS data lakes and warehouses.

Amazon ElastiCacheAmazon ElastiCache

Supports migrations involving Amazon ElastiCache, a fully managed in-memory data store compatible with Redis and Memcached.

Amazon KinesisAmazon Kinesis

Allows for data streaming to Amazon Kinesis, enabling real-time analytics and application integration.

Amazon EMRAmazon EMR

Supports data processing using Amazon EMR, a cloud big data platform for data transformations and analysis with Apache Hadoop and Spark.

Amazon AthenaAmazon Athena

AWS DMS uses Athena queries for data validation of Amazon S3 targets. This lets DMS compare migrated S3 data with the source and report validation failures.

What is AWS Database Migration Service (AWS DMS)

3 min read

AWS Database Migration Service (AWS DMS) is a powerful service provided by Amazon Web Services (AWS) designed to make it easier for users to migrate relational databases, data warehouses, NoSQL databases, and other types of data stores both into and out of the cloud with minimal downtime. This service supports a wide array of source and target databases, including but not limited to Oracle, MySQL, PostgreSQL, Microsoft SQL Server, MongoDB, and Amazon's own database services like Amazon Aurora, Amazon RDS, and Amazon DynamoDB. 

Zero-ETL integrations for self-managed Oracle, SQL Server, MySQL, and PostgreSQL databases replicate transactional data to Amazon Redshift without requiring complex data pipelines. Database and table filtering lets you select the data to replicate.

The primary goal of AWS DMS is to simplify the complex and potentially time-consuming process of database migration. It achieves this by continuously replicating the data from the source database to the target database, allowing the migration to occur with minimal impact on the operational systems. This means that applications can continue to interact with the original database while the migration is in progress, significantly reducing downtime and ensuring that businesses can maintain continuity. 

For heterogeneous migrations requiring stored procedures and secondary database objects, DMS provides built-in Schema Conversion. Alternatives include the downloadable AWS Schema Conversion Tool; homogeneous migrations can use the source engine's native schema export tools.

DMS creates target tables and their associated primary keys if they do not already exist. You can also pre-create the target tables yourself.

One of the key strengths of AWS DMS is its flexibility. It can be used for a variety of migration scenarios, from simple one-time migrations to continuous data replication for real-time analytics or disaster recovery purposes. AWS DMS Serverless automatically provisions, monitors, and scales migration resources to meet demand. With on-demand replication instances, you manually estimate, monitor, scale, or provision resources to peak demand. 

DMS also offers built-in native tooling for homogeneous data migrations. This serverless option does not use replication instances and automatically monitors and scales migration resources for supported database engines.

Security in AWS DMS is also a top priority. The service includes features like encryption at rest using AWS Key Management Service (KMS), encryption in transit using SSL, and network isolation using Amazon Virtual Private Cloud (VPC). These features help ensure that your data remains secure throughout the migration process. Despite its capabilities, AWS DMS is known for its ease of use. The setup and configuration process is straightforward, guided by an intuitive web interface. Users can start their first migration within minutes without extensive training. 

Furthermore, AWS DMS is cost-effective, as AWS charges for the compute resources used during the migration and any additional log storage, making this a scalable solution for businesses of all sizes. 

In summary, AWS Database Migration Service is a comprehensive, flexible, and secure solution designed to ease the complexity of migrating databases to the AWS cloud. Its support for a wide range of databases, real-time replication capabilities, emphasis on security, and ease of use make it a valuable tool for companies looking to migrate their databases with minimal downtime and disruption.

AWS architecture icons are the property of Amazon Web Services. BlowStack is not affiliated with or endorsed by AWS.