Redgate SQL Compare -- What's to compare, save time and money!
Updated April 01, 2021
Redgate SQL Compare -- What's to compare, save time and money!
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Redgate SQL Compare
SQL compare is used in the department mainly during releases and the occasional issue finding (differences between live and dev environments).
Years before we did use a source control solution, but that caused more problems than it solved, so I use this software to deploy DB changes from our dev to live platforms. It's more manual, but it gives me the opportunity to review the differences, and from time to time question the choices of the changes!
Years before we did use a source control solution, but that caused more problems than it solved, so I use this software to deploy DB changes from our dev to live platforms. It's more manual, but it gives me the opportunity to review the differences, and from time to time question the choices of the changes!
- It allows you to set up projects for repetitive comparisions.
- It organises object differences very well, with filters and searches available on top.
- Redgate displays the differences between objects very clearly at script level.
- It's created deployment scripts that you can either run yourself, or complete using the application.
- So far so good. I have to be honest, it's not a complicated application, and so far hasn't caused me any issues or to question the choices of the developers!
- The top benefit is time-saving in deployment. While it's still a manual process overall, it's so much better than doing this with SSMS and Winmerge!
I was familiar with the quality of Redgate's products at the time of making the purchase decision. I checked out a trial version to make sure I could achieve what I wanted from the application, but I never made comparisons with other vendors tools on this occasion. Pricing-wise, it wasn't worth the effort to spend time making alternative comparisons.