G2 Crowd Acquires Siftery to Create a New Way to Buy and Manage Software Spend 🚀

Red Gate SQL Compare

4.6
(17)

SQL Compare makes comparing databases simple and fast. Create scripts to deploy differences or changes to databases.

Work for Red Gate SQL Compare?

Learning about Red Gate SQL?

We can help you find the solution that fits you best.

Red Gate SQL Compare Reviews

Ask Red Gate SQL a Question
Write a Review
Filter Reviews
Filter Reviews
  • Ratings
  • Company Size
  • User Role
  • Industry
Ratings
Company Size
User Role
Industry
Showing 17 Red Gate SQL reviews
LinkedIn Connections
Red Gate SQL review by User in Internet
User in Internet
Validated Reviewer
Verified Current User
Review Source

"Indispensable"

What do you like best?

Wonderful software for keeping the schema of your databases in sync. I could not do without. I tried but my databases got out of sync very soon. I love generating the scripts from SQL Compare and then uploading them on the live machines and deploying them.

What do you dislike?

It could do without bugs. Some bugs when you save change scripts, but nothing deal-breaking. Also, would be nice to have sequential naming for the files - I have to manage the naming myself.

Recommendations to others considering the product

You should really get Data Compare too. They work together. And also Source Control. In fact, you should get the SQL Toolbox if you can afford it.

What business problems are you solving with the product? What benefits have you realized?

Keeping my database schemas in sync across servers - development, staging and live. I need to maintain about 50 websites, internationally, and they all use the same database schema. Keeping this up to date across platforms would be a pain.

Sign in to G2 Crowd to see what your connections have to say about Red Gate SQL Compare
Red Gate SQL review by Joe C.
Joe C.
Validated Reviewer
Verified Current User
Review Source

"Best one of comparison tool"

What do you like best?

The variation from point and shoot comparisons with all of the default options to getting very specific with filtering.

Often times it is very useful to be ale to remove items such as user permissions but if that is what needs comparing, then the granularity is great

What do you dislike?

Little bit clunky to use as a tool for a many to many scenario where you don’t have a known good baseline to work from.

What business problems are you solving with the product? What benefits have you realized?

Despite having a fairly rigid deployment pipeline, we still find drift in the schema across our application DBs and for fine grained detail, this is the best tool we have found.

What Other Non-Relational Databases solution do you use?

Thanks for letting us know!
Red Gate SQL review by HARDIK C.
HARDIK C.
Validated Reviewer
Verified Current User
Review Source

"SQL compare is not a Clear Winner in Few Areas"

What do you like best?

Installation was fairly quick and easy.When I first launched SQL Compare 9.0, I was presented with a dialog box that was intuitive and simple to use. I was able to immediately start comparing databases, with no steep learning curve to overcome. The results of the comparison seemed straightforward and easy to understand at first

What do you dislike?

As I got further into the process, I had difficulty figuring out how to perform certain actions. One problem I had was getting past the errors for the full-text indexes. Full-text indexes weren’t listed in the object list in the output. I removed full-text catalogs from the output via the filters, but this had no effect on the output. I eventually figured out that you can select to ignore full-text indexes as a project option and that there’s no other way to remove full-text indexes from the results. Changing the project options means rerunning the comparison to get a new set of results.

Recommendations to others considering the product

Red Gate's SQL Compare is a product I have used for years and I love the latest version. Data and Schema Compare tools are very expensive!There are much cheaper alternative, But I am thinking in the short term the purchase would hurt but in the long term it would more than pay for itself in lots of ways.

What business problems are you solving with the product? What benefits have you realized?

the RegGate tool set is so useful for us as we run our operation on large set of clients with their all four environments Dev, Test, Stage, Live should be always in sync in order to work.. so with compare schema and Data tools from red gate we create the synchronization scripts along with the comparison of actual data streams as well.

Red Gate SQL review by Administrator
Administrator
Validated Reviewer
Review Source

"Excellent tool for Data comparision"

What do you like best?

This is the best tool in industry that I've came across till date, as it makes life simpler in many complex situations. RedGate is very easy to use, easy to compare the data between two Databases, even at table level and the best part is that it even generates scripts for the data difference found, so that Data can be synchronized just by running those scripts.

What do you dislike?

Nothing that I dislike regarding this tool, except that the license cost is little high which I personally felt.

Recommendations to others considering the product

I would recommend 10/10

What business problems are you solving with the product? What benefits have you realized?

It is mainly used in situations where data is corrupted or deleted, or when replication has issues and when a snapshot cannot be applied, data can be compared with RedGate, and the difference can be synchronized with the Scripts generated, hence eliminating the need for Snapshot application. This helps especially when the Publication Database/Tables are huge.

Red Gate SQL review by Mohit S.
Mohit S.
Validated Reviewer
Verified Current User
Review Source

"Great tool to compare and deploy database scripts"

What do you like best?

It does a great job of comparing database difference and generating a visual report of the same. You can then generate a script of the changes.

What do you dislike?

It does not work seamlessly with DLM automation as a part of the SQL toolbelt. The errors are not intuitive when working on DLM, and it need DBO access to the database, not just read/write.

What business problems are you solving with the product? What benefits have you realized?

Generating automated script for SQL database deployments.

Red Gate SQL review by Maurizio M.
Maurizio M.
Validated Reviewer
Verified Current User
Review Source

"Great software for database diff"

What do you like best?

It's a really powerful tool. We used since 7 years SQL Compare and SQL Data compare. We've used with sql server 2005, 2008, and now with sql server 2012. It's useful the object filter (choose only, for example, role, stored procedures, functions, tables, etc...), great the find function and the deployment wizard, that bring you out the script to upgrade/etc your target database/tables/etc.

What do you dislike?

sometimes the script it's a little bit messy, but you can fix it in an easy way by setting the options (also for the project). sometimes you could get an error if you have some linked server in your stored procedures or function or some transaction, there are hints about that on the web (setting up transaction isolation level read uncommitted, and so on...)

Recommendations to others considering the product

buy also SQL DataDiff, it's a great tool for database management.

What business problems are you solving with the product? What benefits have you realized?

it simplify and make really fast our deploy on systems other than development. make a diff between server and..that's it, you've the script. of course we have to be careful about that (ALWAYS check and look at the script)

Red Gate SQL review by Administrator in Higher Education
Administrator in Higher Education
Validated Reviewer
Verified Current User
Review Source

"Great Tool for Database Comparison"

What do you like best?

I love the SQL Search feature. When working with large databases it can be hard to keep track of objects when multiple changes are being made by multiple users. The SQL Search Feature lets you search for a column name for example and will show you every instance of where that column name occurs in the database.

What do you dislike?

So far the product has been meeting my needs and I cant quite pinpoint anything at this point that I do not like as the tasks I have had to complete have been quite simple and I have been able to do them with ease.

Recommendations to others considering the product

A very handy tool for managing migrations. I would recommend using the SQL Compare if you have seperate development, test and production environments. It will make moving data object quite easy

What business problems are you solving with the product? What benefits have you realized?

When moving data from a testing to a production environment, the SQL Compare lets you ensure consistency between versions and manages the script creation for that process in a very easy to use manner. It saves the DBA having to write alot of extra code.

Red Gate SQL review by Luca C.
Luca C.
Validated Reviewer
Verified Current User
Review Source

"Really useful to save your time"

What do you like best?

Ease of use, immediate result.

I use this software everyday, with this you can compare different tables, storeds and SQL objects, discovering easily the differences and findout an immediate solution regarding the alignment of SQL servers.

What do you dislike?

The only hassle is having to buy a new license if you are comparing SQL Server environments more updated than the one used. For example, if you have the version of 2008 you can not compare a table SQL Server 2008 with another table SQL Server 2012.

Recommendations to others considering the product

Weigh carefully which version to buy depending on the version of SqlServer you are using

What business problems are you solving with the product? What benefits have you realized?

I do not waste time searching independently any sql difference between different environments, most of the porting to production environments are scripted directly from SQL Compare.

Red Gate SQL review by Barbara R.
Barbara R.
Validated Reviewer
Verified Current User
Review Source

"Excellent tool for comparing databases"

What do you like best?

It's a really powerful tool. I have used it for about 6 years SQL Compare and SQL Data compare. I've used with SQL server 2005, 2008, and now with SQL server 2012. It has a useful object filter for the role, stored procedures, functions, tables, etc..., find function and the deployment wizard, that bring you out the script to upgrade/etc your target database/tables/etc.

What do you dislike?

Sometimes the script is messy and you need to examine it before you deploy. Also, it doesn't alway catch if there is are key constraints.

Recommendations to others considering the product

Would also recommend SQL Diff and SQL Data Compre

What business problems are you solving with the product? What benefits have you realized?

It is a great tool for moving from development to production.

Red Gate SQL review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Best tool I've ever used to keep databases in sync"

What do you like best?

I love how easy it is to use to find differences between databases. The ability to create scripts to update one database to another is great. There are so many options to choose - whether to sync everything, just table differences, procs, views, etc. The "ignore" list makes it simple to determine what you want to include in the compare.

What do you dislike?

I haven't found anything I particularly dislike.

Recommendations to others considering the product

If you have the need to maintain multiple like databases or need to keep development and production databases in sync, this is the tool for you. Being able to compare databases, backups, snapshots, source control, etc. is critical and so easy with SQL Compare.

What business problems are you solving with the product? What benefits have you realized?

As a developer of versioned software, I need to be able to track changes we make to our deliverable databases. SQL Compare allows me to easily compare the current development database to production databases to identify and script the necessary changes to bring it to the same level as the development database.

SQL Compare has saved my company so much money in saved development hours, and significantly reduced the number of errors encountered while creating deliverable database schemas.

Red Gate SQL review by User in Computer Software
User in Computer Software
Validated Reviewer
Verified Current User
Review Source

"Industry Leading Software"

What do you like best?

Very easy to compare similar databases and find differences between records. It seems like almost very scenario is covered.

What do you dislike?

I can not think of anything that I dislike about this software.

What business problems are you solving with the product? What benefits have you realized?

We provide a software platform that utilizes a single tenant database architecture. This software is imperative to keep us running efficiently.

Red Gate SQL review by User in Information Technology and Services
User in Information Technology and Services
Validated Reviewer
Verified Current User
Review Source

"Good tool for database conversions"

What do you like best?

Intuitive interface which walks you through table selection and deployment options.

What do you dislike?

The tool could use better error-handling, especially when a SQL script throws an error and the results include the entire deployment results up to the point of the error.

What business problems are you solving with the product? What benefits have you realized?

We use the tool to quickly bring forward common tables for new iterations of older databases.

Red Gate SQL review by Administrator
Administrator
Validated Reviewer
Verified Current User
Review Source

"Saving time on dB migrations"

What do you like best?

Ease of use, scripting possibilities, multiple. Type of sources: live dB, backups, source control...

What do you dislike?

The output of all the data discrepancies is not that trivial in its interpretation; would I do better? Hardly. :/

What business problems are you solving with the product? What benefits have you realized?

Database migration in mimures

Red Gate SQL review by McCourt C.
McCourt C.
Validated Reviewer
Review Source

"Sql Compare - Really speeds up deployment"

What do you like best?

The schema compare wizard is really something special.

What do you dislike?

The cost is a little prohibitive for sole developers.

Recommendations to others considering the product

If you are part of a larger organisation then definetly make the case to buy this from your Management.

What business problems are you solving with the product? What benefits have you realized?

We are activly using the product to replicate schema's acros multiple sites and client.

Red Gate SQL review by User
User
Validated Reviewer
Review Source

"Handy tool"

What do you like best?

A simple GUI to compare data between two environments was very cool and useful

What do you dislike?

The interface could be better but otherwise no major complaints

What business problems are you solving with the product? What benefits have you realized?

We use it to compare data between different environments and for syncing up test data between environments

Red Gate SQL review by Consultant
Consultant
Validated Reviewer
Review Source

"Great Comparison Tool"

What do you like best?

Easy to use interface and returns reliable search results

What do you dislike?

Can take a while to load up when first using

What business problems are you solving with the product? What benefits have you realized?

Used to compare Stored Procedures on multiple instances to sync code across the servers.

Red Gate SQL review by Administrator in Information Technology and Services
Administrator in Information Technology and Services
Validated Reviewer
Review Source

"Great Product"

What do you like best?

Best available product for this purpose.

What do you dislike?

Nothing to dislike. Always welcome and excited for updates and new features.

What business problems are you solving with the product? What benefits have you realized?

Comparing SQL objects.

Kate from G2 Crowd

Learning about Red Gate SQL Compare?

I can help.
* We monitor all Red Gate SQL Compare reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. Validated reviews require the user to submit a screenshot of the product containing their user ID, in order to verify a user is an actual user of the product.