Beyond Compare from Scooter Software headquartered in Madison is a utility for comparing different version of documents and seeing the differences. It also allows changes to be merged and synchronized.
N/A
Redgate SQL Toolbelt Essentials
Score 8.4 out of 10
N/A
Redgate's SQL Toolbelt Essentials includes industry-standard tools for SQL Server development & deployment, enabling users to include SQL Server databases in agile processes and enabilng developers to embed robust and scalable development practices.
Beyond Compare is extremely good at the task of comparisons, whether that is text file comparisons or folder comparisons. It does a great job of easily highlighting the differences for users, and giving them the option of merging (in the case of text files) or synchronizing (in the case of folders.) In either case, no one on my team has ever had any reason to reach for another different tool.
We use SQL Compare to troubleshoot performance problems quite a bit since our data model is more like a template and not everything is 100% in sync and customization occurs between different client databases. We continually get pulled into performance issues and the developers will say Client A is performing different than Client B, why? Using SQL Compare, we usually find that one client was tuned and had indexes altered or added that weren't deployed to all clients or other objects weren't deployed correctly during the release. On the other hand, since our data model practices allow client databases to drift I tried to create a new golden image by trying to compare multiple databases based on the same data model and found it to be a very difficult process to complete using SQL Compare. SQL Compare gave me too much information and doesn't allow enough filtering to eliminate a lot of the noise.
Simple and easy comparison of database schemas and data. Differences can be copied or synced from one database to another with a click of a button.
You can save "projects" so that you can easily rerun a previous comparison whenever you need to.
It has a very simple, easy to learn interface. I've never needed to read any documentation or watch any tutorials in order to figure out how to do something.
For date formatting discrepancies the software does not automatically mark the dates as equivalent; for instance ‘2019/10/15’ vs. ‘15-OCT-2019’. This would be considered a difference.
The columns/report must be ordered similarly. If extra data is available in one file, it should be removed or extra rows will be marked as differences.
For spreadsheet comparison, the user must save the file on the proper tab and then “recompare” within the tool. There is no way to switch between sheets in the software.
Pricing.... I wish there was an inexpensive developer version I could buy for myself.
Portability.... I would like to use it from a flash drive so I can use it where ever I am asked to work.
Unbundled.... This may be available already but I dont' recall I can buy it cheaply as a stand-alone product. Its only part of the bundle - cost effectively.
Again, given the intuitive nature of this program, there is barely any learning curve needed. It is simple, reliable, accurate, and just one of those tools you always have with you and rarely think about until you don't have it. Then it is a case of OMG what was I thinking? This program is just very easy to use, and that makes it more valuable to me than some of my other software tools that cost significantly more.
I have never needed support for this product other than learning how to use a new feature I was not familiar with. User forums and user groups that have used this product for their own purposes have always sufficed for anything that I needed help using with the product. Some of the features could be a little better outlined, but overall very easy to use.
We've tried many: Code Compare, Meld, UltraCompare, and WinMerge. None of them have the depth of features and speed to handle the work we throw at Beyond Compare. The multi-tabbed interface allows us to sync multiple servers at the same time. It understands multiple file types, metadata, and encodings. It's the best tool for the job.
I've used Visual Studio Database Projects for this type of work in the past with some success, but Redgate SQL Compare is faster, more transparent, and simply easier to use. Faster is self explanatory. More transparent, means that it's much easier to set up your desired options for schema change deployment scripts. Easier to use, It's really dead simple. Start a project, connect your source, connect destination, click compare.
