We performed a comparison between HiT Software DBMoto and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about NetApp, Fivetran, Dell Technologies and others in Data Replication."DBMoto was very simple to set up and move our tables to the Oracle DB."
"The most valuable features are that is easy to install and it is user-friendly."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"The solution is easy to use and developer friendly."
"It is easy to set up the solution."
"The scalability of SSIS is good."
"It's a competent product."
"SSIS integrates well with SQL servers and Microsoft products."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It's already very user-friendly and has a good dashboard."
"This product would be improved with additional built-in functions for simpler date conversion, as well as for data type transformations."
"Pricing is an area that needs improvement."
"I would like to see better integration with Power BI."
"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."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"Future releases should improve the data lineage, as it currently is not good."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
Earn 20 points
HiT Software DBMoto is ranked 16th in Data Replication while SSIS is ranked 2nd in Data Integration with 69 reviews. HiT Software DBMoto is rated 9.0, while SSIS is rated 7.6. The top reviewer of HiT Software DBMoto writes "Replication monitor feature is helpful in that it allows a quick view of the status, errors, and results of the last replication". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". HiT Software DBMoto is most compared with Syniti Data Replication, Informatica PowerCenter and E2E Bridge, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
We monitor all Data Replication 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.