Filter Ratings and Reviews
Filter 33 vetted Redgate SQL Compare reviews and ratings
Reviews (1-6 of 6)
November 01, 2019
Redgate SQL Compare: the only SQL comparison tool you'll ever need!
My small web development team uses Redgate SQL Compare to help us manage our SQL databases across different environments (development, QA, and production, etc.). It eliminates the tedious and manual task of comparing database schemas and synchronizing them and their data across these different environments.
- 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.
- I honestly can't think of anything I don't like or anything I would change.
February 07, 2020
SQL Data Compare, not pretty, but it works
- Redgate SQL Compare is used in multiple departments within our organization. My company hadn't used Redgate products previously to my hiring, but it is spreading out through the company.
- One of the challenges working with data, especially in different environments, is finding differences/changes that have occurred in the data. Redgate SQL Compare makes this very easy to accomplish, highlighting the differences and even giving you the option to update the data on one of the systems.
- Data comparison
- Data update
- Speed of execution. It can be slow to run, especially on large datasets.
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!
We use Redgate's SQL Compare to create our upgrade scripts for our application upgrades and deployments. We honestly couldn't do our upgrades without it! We make changes constantly to our database schema for our applications and managing those changes can be a hassle, let alone keeping track of what we need to put in the upgrade or new deployment scripts. Redgate's tools make this painless and worry free! Just check in your database changes into SQL and SQL Compare does the rest!
- Extremely fast!
- Compares from source control, not just physical databases. No need to keep copies of databases of varying versions laying around.
- Command line tools integrate easily into automated build processes.
- Even has plugins for products like Octopus Deploy!
- Not the best at initial setups. Sometimes there are error messages that have no bearing on what the problem really is.
- Documentation sometimes can be lacking, but their support team will make up for that.
For my experience, SQL Compare is a DBA's "must have" software. Thanks to SQL Compare you can quickly and easily compare different databases in different environments. Personally, I use it above all to make comparisons between development or testing environments with for example production environments.
- Comparison speed
- Immediacy in the highlighting of differences
- Easy to use
- Some features or default preferences are not activated and are a bit hidden between the Options flags
- License fee slightly high
- If you upgrade the SQL server, you need to upgrade the version of SQL
April 03, 2017
RedGate makes awesome SQL Server dev tools!
I use RedGate SQL Compare within my department. In database development, it's an awesome tool to keep database structures and code in sync, especially with there are many hands working on a database. It helps in determining the REAL scope of structure and code migrations. I use it to both generate deployment scripts for later use and documentation and also to effect some migrations immediately. It depends on if I am trying to sync multiple dev dbs or a dev to qc db or from a dev/qc db to a prod db. It is very thorough in its comparisIt's. Its not unusual that I have a few of those "oh I forgot about that change" moments when running it. It saves me lots of time and frustration in performing db change migrations right the first time. I don't ever want to be without it!!
- Deep, thorough SQL Server db comparisons in places you might not think to look.
- Gives me flexibility on how I want to save or execute the SQL Compare results.
- Remembers settings between uses that speed me in using it.
- Has a clear and effective interface.
- 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.
Redgate SQL Compare Scorecard Summary
Feature Scorecard Summary
About Redgate SQL Compare
Categories: Database Management
Redgate SQL Compare Technical Details
| Operating Systems: | Unspecified |
|---|---|
| Mobile Application: | No |