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."It's pretty useful when we need to migrate something big from a different type of database that AWS Data Migration Services supports."
"The most valuable feature of AWS Database Migration Service is it catches all the history changes, such as inset, observe, and delete. It tracks everything."
"Support is helpful."
"This solution is very good at mini-batch processing."
"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."
"Scalable and stable solution for migrating databases to AWS, with valuable features such as parallel full load and continuous data replication."
"The most valuable feature of the solution is the one I use for report generation. The security risk is very low."
"The Schema Conversion Tool helps to covert the convertible objects and define the non-convertible objects"
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The data reader is the most valuable feature."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The initial setup was easy."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The UI is very user-friendly."
"Sometimes, the migration processes are not manageable"
"The live duplication has a delay of two minutes, which can be an issue."
"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."
"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."
"This solution can offer more tweaks where the latency can be brought down to fifteen seconds."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"If they had some sort of functionality where, at a specific point in time, if I want to start a new job, it should automatically pick up from where it has been left rather than having people worry about the exact job number and the timing."
"Database Migration Service could be more integrated. I think that it makes sense to add integration to these functions. For example, AWS Glue has a feature called Orchestrator to create data flows, and that's more straightforward."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
"SSIS should be made a little bit more intuitive and user-friendly because it needs an expert-level person to work on it."
"It would be nice if you could run SSIS on other environments besides Windows."
"It needs more integration tools, so you can connect to different sources."
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 Informatica Cloud Data Integration, 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.