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 installation is easy."
"We particularly like that this solution has the facility to integrate with all ETL tools."
"This solution is very good at mini-batch processing."
"Support is helpful."
"The most valuable feature of the solution is the one I use for report generation. The security risk is very low."
"The most valuable features of the AWS Database Migration Service are the ease of migration, beneficial storage system, security, and simple instance creation. Additionally, the cloud that is provided is more complete than other solutions."
"The solution is instantaneous. We can launch the service and reduce the end number of manpower."
"If your infrastructure is already on Amazon, it simply makes the most sense to use a tool officially provided by them as an additional service, rather than having to rely on a third-party solution."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"The performance is good."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"We can connect with multiple data sources easily using an external connector in SSIS."
"SSIS integrates well with SQL servers and Microsoft products."
"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."
"Whatever solution worked today can not be reused in the next migration."
"The cost is a concern. We use DMS because of its simplicity, but the price could definitely be more competitive."
"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."
"The performance of data migration could be smoother."
"We would like to see some improvement in the performance of large scale procedures, such as when we migrate from Oracle to csSQL."
"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."
"The initial setup can be difficult for beginners in AWS Database Migration Service. You will need the training to complete it."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"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."
"Tuning using this solution requires extensive expertise to improve performance."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"Options for scaling could be improved."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The solution could improve by having quicker release updates."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
More AWS Database Migration Service Pricing and Cost Advice →
AWS Database Migration Service is ranked 2nd in Cloud Data Integration with 26 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.