AWS Database Migration Service Reviews

Name: AWS Database Migration Service
Brand: Amazon Web Services (AWS)
Rating: 4.0 (30 reviews)

Vendor: Amazon Web Services (AWS)

4.0 out of 5

30 reviews
93% willing to recommend

265 followers

Post review

What is AWS Database Migration Service?

AWS Database Migration Service, also known as AWS DMS, is a cloud service that facilitates the migration of relational databases, NoSQL databases, data warehouses, and other types of data stores. The product can be used to migrate users' data into the AWS Cloud or between combinations of on-premises and cloud setups. The solution allows migration between a wide variety of sources and target endpoints; the only requirement is that one of the endpoints has to be an AWS service. AWS DMS cannot be used to migrate from an on-premises database to another on-premises database.

Get the AWS Database Migration Service Buyer's Guide and find out what your peers are saying about AWS Database Migration Service, Informatica Intelligent Data Management Cloud (IDMC), AWS Glue and more!

AWS Database Migration Service is the #2 ranked solution in top Cloud Data Integration solutions. PeerSpot users give AWS Database Migration Service an average rating of 8.0 out of 10. Based on the analysis of the 30 most recent AWS Database Migration Service reviews, the overall sentiment is positive, with a sentiment score of 6.8. (Among the lowest in the category). AWS Database Migration Service is most commonly compared to Informatica Intelligent Data Management Cloud (IDMC): AWS Database Migration Service vs Informatica Intelligent Data Management Cloud (IDMC). AWS Database Migration Service is popular among the large enterprise segment, accounting for 69% of users researching this solution on PeerSpot. The top industry researching this solution are professionals from a financial services firm, accounting for 21% of all views.

Buyer's Guide

AWS Database Migration Service

December 2024

Get the report

Helped 823,875 peers since 2012

Featured reviews

StevenLai

Sr. Data Engineer at Amrock

Sometimes we encounter errors, and the error messages from DMS are very ambiguous and sometimes misleading. For example, if we connect to an incorrect instance with incorrect setups, it will not say the connection failed. Instead, it says the DMS task failed with an unclear error message like 'subtask AWS failed', which does not help. The connection should fail if we are connecting to the wrong instance, but the endpoint connection still succeeds.

Read full review

Hafiz Mannan

Professional Service Consultant- Data Systems [Oracle, OCI, AWS, Azure, Data Bricks] at Self-employed

Key features of DMS that are effective for large-scale migrations include the continuous data replication capability, which minimizes downtime, and support for heterogeneous database migrations. Additionally, it allows for multi-threaded processing and provides monitoring capabilities, making it easier to manage the migration process. The monitoring capabilities are robust, providing detailed logs and metrics through CloudWatch. It allows me to track the status of migration tasks in real time, assess performance, and quickly identify and resolve any issues that arise during the migration process. I encountered a data conversion issue related to changing time formats from UTC to a different format. By leveraging the transformation feature within DMS, I successfully converted the data to meet the customer's requirements. I ensure that sensitive data is encrypted in transit and at rest using AWS Key Management Service (KMS). Additionally, I conduct thorough assessments of access controls and compliance requirements specific to the client's industry. I stay updated with the latest features and enhancements related to AWS services by regularly attending webinars, participating in AWS training sessions, and following industry publications. Engaging with the AWS community through forums and conferences provides valuable insights and updates. Overall, I rate the product a nine out of ten.

Read full review

Shehab Saad

Business Intelligence Manager & Data Analytics (Retail Business) at a retailer with 1,001-5,000 employees

In my experience, AWS Database Migration Service performs well for its primary purpose of data migration. One area that could be improved is its support for non-AWS file formats, particularly when integrating data from sources stored outside of AWS. For example, handling AWS Data Lakes, Delta Lake, or Hadoop file formats stored in S3 requires extensive configuration and isn't always straightforward. It would be beneficial to streamline this process to ensure smoother migrations from non-AWS environments to AWS. As for additional functionality, I think enhancing support for these external file formats and simplifying configuration steps would be valuable improvements for the service.

Read full review

AWS Database Migration Service mindshare

As of December 2024, the mindshare of AWS Database Migration Service in the Cloud Data Integration category stands at 21.0%, down from 21.2% compared to the previous year, according to calculations based on PeerSpot user engagement data.

Cloud Data Integration

PeerAnalyst reports

Type	Title	Date
Category	Cloud Data Integration	Dec 17, 2024	Download
Product	Reviews, tips, and advice from real users	Dec 17, 2024	Download
Comparison	AWS Database Migration Service vs AWS Glue	Dec 17, 2024	Download
Comparison	AWS Database Migration Service vs Informatica Intelligent Data Management Cloud (IDMC)	Dec 17, 2024	Download
Comparison	AWS Database Migration Service vs MuleSoft Anypoint Platform	Dec 17, 2024	Download

Title	Rating	Mindshare	Recommending
Informatica Intelligent Data Management Cloud (IDMC)	4.0	N/A	93%	181 interviews Add to research
AWS Glue	3.9	24.8%	91%	46 interviews Add to research

Valuable Features

"DMS's architecture is highly beneficial, allowing for scalable migrations of large datasets."
"The most valuable feature is its ability to get all the changes in our data and store that in an S3 bucket."
"One of the features, I find most valuable is its ability to apply rules and transformations to data during real-time integration. This includes changing schema names or table structures on AWS without delaying the data flow. Initially, full migrations can vary widely in time depending on the source system; for instance, a large Magento database might take up to six months, while smaller databases like IBM DB2 could migrate within hours. Once set up, AWS DMS ensures real-time synchronization using Change Data Capture (CDC), maintaining data integrity throughout the process."

Room for Improvement

"There could be enhancements in the product intelligently covering more scenarios to prevent crashes or failures."
"Sometimes we encounter errors, and the error messages from DMS are very ambiguous and sometimes misleading."
"In my experience, AWS Database Migration Service performs well for its primary purpose of data migration. One area that could be improved is its support for non-AWS file formats, particularly when integrating data from sources stored outside of AWS. For example, handling AWS Data Lakes, Delta Lake, or Hadoop file formats stored in S3 requires extensive configuration and isn't always straightforward. It would be beneficial to streamline this process to ensure smoother migrations from non-AWS environments to AWS. As for additional functionality, I think enhancing support for these external file formats and simplifying configuration steps would be valuable improvements for the service."

ROI

Pricing

"In terms of pricing, I'd rate it an eight out of ten, considering it's a well-priced solution."
"The product is pretty expensive"
"The pricing is on the higher side."

Popular Use Cases

Service and Support

Deployment

Scalability

Stability

AWS Database Migration Service is generally stable and reliable, with users experiencing minimal issues. Most users rate stability between six to nine out of ten. Some encountered challenges with large data volumes and continuous use, particularly during source maintenance or failover. Generally, there are no crashes or glitches, and it's effective for quick migrations. It automatically recovers in case of minor breakdowns. Technical support was helpful during setup, ensuring smoother operations thereafter.

These insights are based on the in-depth reviews provided by peers to help you make a better buying decision.

Download our AWS Database Migration Service Buyer's Guide for additional reliable information.

Review data by company size

By reviewers

By visitors reading reviews

Top industries

By visitors reading reviews

Financial Services Firm

21%

Computer Software Company

14%

Government

Manufacturing Company

Insurance Company

Energy/Utilities Company

Retailer

Real Estate/Law Firm

University

Healthcare Company

Media Company

Educational Organization

Construction Company

Non Profit

Comms Service Provider

Recreational Facilities/Services Company

Transportation Company

Wholesaler/Distributor

Hospitality Company

Logistics Company

Legal Firm

Consumer Goods Company

Outsourcing Company

Performing Arts

Recruiting/Hr Firm

Pharma/Biotech Company

Engineering Company

Compare AWS Database Migration Service with alternative products

Learn more about AWS Database Migration Service

AWS Database Migration Service allows users to perform one-time migrations, as well as replications of ongoing changes to keep sources and targets in sync. Organizations can utilize the AWS Schema Conversion Tool to translate their database schema to a new platform and then use AWS DMS to migrate the data. The product offers cost efficiency as a part of the AWS Cloud, as well as speed to market, flexibility, and security.

The main use cases of AWS Database Migration Service include:

Migrating from legacy or on-premises databases to managed cloud services through a simplified migration process.
Reliable replication of backup files to minimize downtime and data loss.
Improvement of integration through building of data lakes and performing real-time processing on change data from users' data stores.

AWS Database Migration Service Components

AWS Database Migration Service consists of various components which function together to achieve users’ data migration. A migration on AWS DMS is structured in three levels: a replication instance, source and target endpoints, and a replication task. The components include the following actions:

Replication instance: AWS Database Migration Service provides users with a variety of replication instances, allowing them to select the optimal configuration for their use case. Depending on the instance class an organization selects, their replication instance provides a different amount of data storage.
Endpoint: AWS DMS uses an endpoint to access users' source or target data stores. The connection information is different and depends on the specific data store, but it usually consists of the following information: endpoint type, engine type, server name, port, encryption, and credentials. This information can easily be managed through the AWS DMS console.
Replication tasks: AWS Database Migration Service replication tasks can be used to move a set of data from the source endpoint to the target endpoint. The creation of a replication task is the last required step before starting a migration. Each replication task requires the following settings to be set: replication instance, source endpoint, target endpoint, and migration type options.
Ongoing replication or change data capture (CDC): AWS DMS also has the capacity to capture ongoing changes to the source that is stored while users migrate their data to a target.
Schema and code migration: The product requires assistance from tools such as MySQL Workbench, pgAdmin III, and Oracle SQL Developer to perform schema or code conversion, as it cannot do it on its own.

AWS Database Migration Service Benefits

AWS Database Migration Service offers its users a wide range of benefits. Among them are the following:

The solution ensures minimal downtime, as it continuously replicates the changes to the user’s source database during migration.
AWS DMS provides users with flexibility, as it supports many commonly used databases, including commercial and open-source ones.
The product is user friendly, as it offers an easy set of tasks in the AWS Management Console.
Users of Aurora, Redshift, DocumentDB, and DynamoDB can benefit from the free use of AWS DMS.
AWS Database Migration Service is very reliable because it is a self-healing service that automatically restarts in cases of interruptions.
The product supports both homogenous migrations and heterogenous migrations.
AWS DMS accelerates business growth, as it scales businesses at an affordable price.