We performed a comparison between AWS Database Migration Service and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The product's initial setup phase was very easy."
"The fact that it's well-integrated into multiple targets that are good for different use cases is pretty good."
"This solution is very good at mini-batch processing."
"It's pretty useful when we need to migrate something big from a different type of database that AWS Data Migration Services supports."
"As the solution is on the cloud, we don't have to worry about the maintenance of software."
"For our simple requirement of migration, DMS is just a typical AWS RDS with an IPSec tunnel to Oracle. The most valuable features for us are the networking capabilities like VPCs and VPNs."
"I am very impressed by the scalability of AWS Database Migration Service."
"Even if it does break down, it will automatically recover itself and resumes from where it stopped."
"It is easy to set up the product."
"The main value of any Microsoft product is the ease of use. You can achieve more with less time. That's what's beneficial for me. With many competitors, you might need to spend more time coming up with a solution because you have to focus on taking care of the product."
"The scalability of SSIS is good."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"The initial setup of this solution is very straightforward."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"It's already very user-friendly and has a good dashboard."
"The way that the task settings work, specifically for logging, is really poor."
"The product's performance could be a little bit better."
"Migrating from here and pushing the data from on-premise to AWS cloud is a big challenge and a few more services from AWS would be helpful. For example, we are currently using ILDB internet tools which move data from on-premise to the AWS cloud. A few more services would be really helpful for me to move the master data."
"The initial setup can be difficult for beginners in AWS Database Migration Service. You will need the training to complete it."
"Whatever solution worked today can not be reused in the next migration."
"AWS Database Migration Service can become complex when testing. Other solutions, such as Microsoft Azure makes it easy to do. There are more steps to complete tasks in AWS Database Migration Service than in Microsoft Azure."
"More endpoints need to be supported by AWS Database Migration Service. There's also a need for more control and transparency on the product, including better technical support."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"This solution needs full support for real-time processing."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Improvement as per customer requirements."
"Generic processes should be used instead of custom code for each table."
"The solution could improve by having quicker release updates."
More AWS Database Migration Service Pricing and Cost Advice →
AWS Database Migration Service is ranked 2nd in Cloud Data Integration with 27 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. AWS Database Migration Service is rated 7.8, while SSIS is rated 7.6. The top reviewer of AWS Database Migration Service writes "A cloud solution for live replication but has stability issues". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". AWS Database Migration Service is most compared with AWS Glue, Oracle GoldenGate, Qlik Replicate, Fivetran and Quest SharePlex, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our AWS Database Migration Service vs. SSIS report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
