MssqlMerge vs. SolarWinds Task Factory

MssqlMerge

SolarWinds Task Factory

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
MssqlMerge	Score 8.0 out of 10	N/A	MssqlMerge is a diff and merge GUI tool for Microsoft SQL Server databases used to compare and sync both schema and data changes. The application has tabbed UI, there are several types of tabs responsible for particular application features and scope of tasks. The starting point is a Home tab - it is used to open databases and show summary about database schema and programming objects changes: table definitions, views, stored procedures and so on. From here, users can drill-down details…	$0
SolarWinds Task Factory	Score 8.2 out of 10	N/A	According to the vendor, SolarWinds Task Factory saves time managing tedious ELT/ETL tasks with high-performing SQL Server Integration Services (SSIS) components that can be used within the Visual Studio environment to connect to nearly any data source. Task Factory’s components and tasks have been optimized to ensure fast performance of data-centric applications, and the user can run Task Factory…	N/A

Pricing

MssqlMerge

SolarWinds Task Factory

Editions & Modules

Free: $0
Standard (personal license): $95
one-time fee per user
Standard (multi-user license): 120 ~ 75
one-time fee per user

Task Factory: 1,245 (annual subscription license)
per server
Task Factory Azure Data Factory: 1,495 (annual subscription license)
per ADF node

Offerings

Pricing Offerings
MssqlMerge	SolarWinds Task Factory
Free Trial
Yes	Yes
Free/Freemium Version
Yes	Yes
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

No setup fee

Additional Details

Multi-user license price depends on the number of licensed users. Starting from 5-user license client is getting benefits comparing to a purchase of individual license for each employee.

—

More Pricing Information

Community Pulse
	MssqlMerge	SolarWinds Task Factory
Considered Both Products	MssqlMerge Verified User Anonymous Chose MssqlMerge in my current project we have mssql database hosted in cloud and onprem both and I used MssqlMerge tool with Microsoft database from long back its feature and operation performance is very smooth and easily integrated with others database. hence I like this. Incentivized Helpful?	SolarWinds Task Factory Holly Couch Executive Administrator Chose SolarWinds Task Factory SolarWinds Task Factory has a lot of SQL integrated SSIS in one location that makes it easy to automate nearly every business procedure without integrating with external applications. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory We really did not look at any other products. We had already heard of SolarWinds Task Factory previously. We hired Pragmatic Works for a consulting project and they owned the product at that time and implemented it in-house. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory None Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory It was here from a prior manager, no reason to change to something else. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory ZappySys is an alternative provider that we tested. However, we found the ease of use, set up and installation to be much simplier and quicker using Task Factory. ZappySys has a number of the same connectors but are more difficult to setup and the GUI is not as intuitive and … Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Task Factory does a fair job in terms of address parsing compared to COZYROC and also other variable features in terms connecting to CRM and SharePoint site. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory We wanted more ways to connect with other sources and Task Factory offer the best suited solution. Task Factory was also easier to integrate with our actual code base and was cheaper than the alternative. We were very satisfied with our choice and we recommend Task Factory to … Incentivized Helpful? JS John Stuchly Data Developer Chose SolarWinds Task Factory Cozyroc has a few more connectors, but Task Factory's focus on tasks is a better overall fit for us. ZappySys had some compelling features around web services which seemed a bit more robust, but that was not our primary interest at the time of purchase. Basically, all of … Incentivized Helpful? JH John C Hill Business Intelligence Manager Chose SolarWinds Task Factory n/a Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Dell Boomi, Informatica, Data Stage. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Since I used Task Factory earlier, I went for it. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Haven't performed a competitor analysis in 6 years. Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory When we were doing research on if Task Factory was a viable option for us, we found that the large array of tasks that it offers and the low cost of all of it was much better than the competition. We found that we would have to buy a culmination of tools just to pull together … Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory Task Factory is more than just components. It is more than just monitoring. It is an entire suite of tools for SSIS package development. And this is not a case of someone going wide but not going deep. Task Factory by Sentry One (formerly of Pragmatic Works) goes wide and deep. … Incentivized Helpful? PB Peter Berrens BI consultant Chose SolarWinds Task Factory Task Factory just has more options and tasks needed to run a fully automatic ETL. Incentivized Helpful? AR Al Rubel System Architect Chose SolarWinds Task Factory Cheaper and more flexible. Incentivized Helpful? Ryan Lundahl Senior Business Intelligence Analyst Chose SolarWinds Task Factory I haven't participated in any other evaluations because we had Task Factory when I started here. Incentivized Helpful? Luca Campanelli Senior Betting & Online DB Administrator Development Chose SolarWinds Task Factory No other product was considered because we knew we were safe with this product even when it was still Pragmatic Works (now Sentry One). Before using this product, we downloaded additional third-party tasks, some freeware, but a complete package like the one offered by sentry … Incentivized Helpful? Mickeal Davis Enterprise Architect Chose SolarWinds Task Factory We've only compared it to standard Microsoft, and we selected Task Factory after the 30-day trial. Incentivized Helpful? KC Kang Chen Advanced Data Architect Chose SolarWinds Task Factory It did a better on parsing XML/JSON data. Incentivized Helpful? Steven Gockley, MBA, MCSA DBA / Sr. Data Analyst Chose SolarWinds Task Factory Honestly, I had seen Task Factory being used in a previous shop, and when the need came up I went straight to them. Incentivized Helpful? EC Edward Chow Software Developer Chose SolarWinds Task Factory We have not considered other products. Incentivized Helpful? Karl Wiggins Director, IT Infrastructure & Operations Chose SolarWinds Task Factory CData Software was evaluated initially, and while we chose to go with Task Factory initially due to cost and simplicity, in the end we had to purchase CData's product anyway when Task Factory was not updated to work with Microsoft Dynamics 365 v. 9 for months after it was … Incentivized Helpful? Verified User Anonymous Chose SolarWinds Task Factory In the arena of SSIS extension products and services, Task Factory is a strong competitor and checks all of the boxes we needed to have checked at a very reasonable cost. Incentivized Helpful? SM Steve Mayer Technical Project Manager Chose SolarWinds Task Factory No others. Incentivized Helpful?

Features

MssqlMerge

SolarWinds Task Factory

Database Development

Comparison of Database Development features of Product A and Product B
	MssqlMerge 7.0 Ratings 20% below category average	SolarWinds Task Factory - Ratings
Database change management	7.00 Ratings	00 Ratings

Database Administration

Comparison of Database Administration features of Product A and Product B
	MssqlMerge 7.0 Ratings 18% below category average	SolarWinds Task Factory - Ratings
Change management	7.00 Ratings	00 Ratings

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	MssqlMerge - Ratings	SolarWinds Task Factory 9.4 Ratings 11% above category average
Connect to traditional data sources	00 Ratings	9.40 Ratings

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	MssqlMerge - Ratings	SolarWinds Task Factory 9.2 Ratings 12% above category average
Simple transformations	00 Ratings	8.70 Ratings
Complex transformations	00 Ratings	9.60 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	MssqlMerge - Ratings	SolarWinds Task Factory 9.4 Ratings 15% above category average
Integration with data quality tools	00 Ratings	9.20 Ratings
Integration with MDM tools	00 Ratings	9.60 Ratings

Best Alternatives
	MssqlMerge	SolarWinds Task Factory
Small Businesses	DBeaver Score 9.2 out of 10	Skyvia Score 9.9 out of 10
Medium-sized Companies	DBeaver Score 9.2 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
Enterprises	DBeaver Score 9.2 out of 10	IBM InfoSphere Information Server Score 8.0 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	MssqlMerge	SolarWinds Task Factory
Likelihood to Recommend	8.0 (0 ratings)	8.1 (0 ratings)
Likelihood to Renew	- (0 ratings)	8.2 (0 ratings)
Usability	- (0 ratings)	9.1 (0 ratings)
Support Rating	- (0 ratings)	9.1 (0 ratings)
Implementation Rating	- (0 ratings)	8.2 (0 ratings)

User Testimonials
	MssqlMerge	SolarWinds Task Factory
Likelihood to Recommend	personally I work with different types of databases and based on project requirements I have to create multiple databases like in dev qa and prod.here MssqlMerge help me lot when it comes to work with multiple databases.also it help me search querry easily. Incentivized Verified User Anonymous Read full review	Since I started working with this great tool all data analysis programs have been running effectively. Implementation of projects and tasks have been effective and reliable. Data collected from each department gives us working plan on better management of various programs. The Dimension Merge SCD Transform helps us to load large volumes of data within a short period of time. Incentivized Nancy Petrey Business Analyst Read full review
Pros	bulk data Marge efficient and speedy search easy to add multiple databases variety of features Incentivized Verified User Anonymous Read full review	The Slowly Changing Dimension Component saves us a huge amount if time compared to the native SSIS component. JSON Transform is really useful to convert record and send it to rest API. The advanced derived columns allow us to use really cool functions that are not available in the regular transforms. Incentivized Karl Blacquière Bi Architect Read full review
Cons	intra compatibility Merge in-between different types databases enhance features Incentivized Verified User Anonymous Read full review	It was built by Pragmatic Works who sold it to SentryOne and now Solar Winds, concerned about future support. SolarWinds is discontinuing support for related products such as BiXpress. Had issues with connecting to certain versions of SQL Server - would fail when deploying one package - had to deploy the entire solutions. Occasional random failures observed with the Filter tranform. Incentivized Verified User Anonymous Read full review
Likelihood to Renew	No answers on this topic	Task Factory has become a key product for our use of doing ETL work in SSIS. Their custom SSIS components allow us to work simply on the data engineering side of things. We can ignore the lower level work needed to connect to disparate data sources. This allows us to work faster and provide more value to the business Incentivized Verified User Anonymous Read full review
Usability	No answers on this topic	Compared to some of the other transformations I have worked with, it really is pretty simple for the type of functionality you get Incentivized Steven Gockley, MBA, MCSA DBA / Sr. Data Analyst Read full review
Support Rating	No answers on this topic	Overall, the best vendor we currently have on the data side of the house. No issues, issues are resolved very quickly and upgrades go without any issues. Incentivized Steven Gockley, MBA, MCSA DBA / Sr. Data Analyst Read full review
Implementation Rating	No answers on this topic	Overall it went smoothly. Had a couple of gotchas with licensing and upgrading but nothing that really stopped us. Incentivized Steven Gockley, MBA, MCSA DBA / Sr. Data Analyst Read full review
Alternatives Considered	in my current project we have mssql database hosted in cloud and onprem both and I used MssqlMerge tool with Microsoft database from long back its feature and operation performance is very smooth and easily integrated with others database. hence I like this. Incentivized Verified User Anonymous Read full review	I've not found too many tools to bolt onto SSIS that encompass what you get with Task Factory. I have used some Enterprise ETL tools like Dell's Boomi, but did not find it to be very intuitive. Task Factory does not leave you guessing how to use its components. Additionally, their support is very responsive and helpful. Incentivized FC Frank Coulter Database Operations Manager Read full review
Return on Investment	lots of competitors it's help to accomplish small task Incentivized Verified User Anonymous Read full review	We were able to support our developers with Task Factory features and reduce the development time by 40%. Recently Task Factory has changed their pricing module and it seems to be pretty costly for our process. Our business team has started to evaluate whether this is worth it going forward. Incentivized Verified User Anonymous Read full review
ScreenShots	MssqlMerge Screenshots	SolarWinds Task Factory Screenshots