SQL Compare Reviews & Product Details

Redgate creates ingeniously simple software to help data professionals get the most value out of any database, anywhere, through the provision of end-to-end Database DevOps. More than 200,000 people globally, including 92% of the Fortune 100, trust Redgate to deliver ingeniously simple software. SQL Compare is the industry standard for comparing and deploying SQL Server database schemas quickly and accurately. 71% of the Fortune 100 use SQL Compare to compare SQL Server databases – because it's relentlessly tested, easy to use, creates flawless deployment scripts, and saves time. Whether you need to deploy changes or explore the differences between two SQL Server databases, SQL Compare is the fastest way to compare and deploy SQL Server schemas. It enables yo to find and fix errors, and create deployment scripts in minutes. Find out more about SQL Compare: https://www.red-gate.com/products/sql-development/sql-compare/

Seller

Redgate Software

Discussions

SQL Compare Community

Languages Supported

English

Solution Type

Best-of-Breed

Overview by

Tey Peryie

Pricing

Pricing provided by SQL Compare.

SQL Compare

Starting at $282.00

1 user Per Year

View More Pricing Information

Top-Rated Alternatives

dbForge Studio for MySQL

View All Alternatives

User Insights

Average based on 28 real user reviews.

Perceived Cost

$$$$$

Typical contract price

$0k - $0k

Per Year

G2 reviews are authentic and verified.

Here's how.

Verified User in Wholesale

Mid-Market (51-1000 emp.)

2/6/2025

"Red Gate Compare fails with a spurious error"

0/5

What do you like best about SQL Compare?

It's great when it works. But it's useless when it doesn't. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

The product fails to compare two SQL databases and returns a vague error message. Red Gate Support requested copies of the database schemas, but due to policy, they cannot be shared offsite. Unfortunately, they are unwilling to extend their logging to help diagnose the issue.

Having used Red Gate tools for over 10 years, I can say that their support was excellent in the past, but that is no longer the case. Review collected by and hosted on G2.com.

Matthew S.

Network Operator

Small-Business (50 or fewer emp.)

11/26/2024

"SQL Compare, best tool out there!"

5/5

What do you like best about SQL Compare?

Easy to compare objects between databases, compare procs, tables, triggers or permissions and sync them up easily. Used regularly to promote changes to production or check where code was changed. Or to recreate a like database with the same structure but without the data and triggers. Highly recommend using SQL compare to make your life easier! Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Lines not lining up make it appear there are more differences than there are, it can be determined that what it is dropping it is also adding due to order etc but it can add to time for review Review collected by and hosted on G2.com.

Cyndi D.

IT Senior Business Analyst

Small-Business (50 or fewer emp.)

11/13/2024

"First Foray into Redgate"

4.5/5

What do you like best about SQL Compare?

Ease of use. Ease of installation. Fills my needs. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Only downside I can think of is that I need to use it at all! Review collected by and hosted on G2.com.

What problems is SQL Compare solving and how is that benefiting you?

SQL Compare has been critical to my work where we integrate in-house developed apps to a program without an API. Without it, I couldn't verify updates to the program wouldn't break our apps. I have been able to prevent several issues due to using it. It is fairly simple to read and interpret. Review collected by and hosted on G2.com.

Verified User in Health, Wellness and Fitness

Mid-Market (51-1000 emp.)

11/18/2024

"I use it daily"

5/5

What do you like best about SQL Compare?

SQL Compare is fast and effective at identifying changes or differences in database structures/DDL. It is also flexible in the things that can be included or excluded from comparisons. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

I'd like the ability to compare versions of the same objects within the same db or objects with different names in different databases. Review collected by and hosted on G2.com.

Robert R.

Mid-Market (51-1000 emp.)

8/8/2024

"Exceptional product"

5/5

What do you like best about SQL Compare?

I does what is says it does, allows me to compare revisions of databases Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

so far nothing and i have been using the product for over 10 years Review collected by and hosted on G2.com.

What problems is SQL Compare solving and how is that benefiting you?

I do development on separate computer that the main server. When i am ready to upgrade the server, the product gives me a path to do so. I will usually replicate the server database first then do the comparison with both this tool and the data Compare tool. The latter allows me to sync data between both databases Review collected by and hosted on G2.com.

Verified User in Gambling & Casinos

Mid-Market (51-1000 emp.)

11/14/2024

"A tool that every DBA or DB developer need to have"

5/5

What do you like best about SQL Compare?

Compare databases before upgrade and generate the upgrade script. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

As a tool for comparing database schema, it have everything that I am looking for. It give every single option to ignore or include. Review collected by and hosted on G2.com.

Verified User in Logistics and Supply Chain

Mid-Market (51-1000 emp.)

12/13/2021

"Purpose Driven Done Right"

4.5/5

What do you like best about SQL Compare?

The interface is easy to use, but it consistently builds out the SQL scripts based upon a wide variety of granular options. It also interfaces with powershell so you can execute the plug-in with those options selected. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

The scripts are not referential aware. It can not handle generating a single script that requires a specific order, such as adding a table before adding new tables that reference it. Also, not all of the options are accessibly via powershell. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Compare:

Keep in mind the functionality still requires some fine-tuning in complex systems, such as RMDBs with foreign key relationships. The license is also quite expensive, but I find it's worth the price. Review collected by and hosted on G2.com.

What problems is SQL Compare solving and how is that benefiting you?

This created a great way to maintain our codebase in a way that does not require a DBA on hand to generate the SQL change scripts. We use this as the key piece in applying source control to all databases in our application. Review collected by and hosted on G2.com.

Verified User in Hospital & Health Care

Enterprise (> 1000 emp.)

10/13/2020

"Handy but slightly tedious"

3.5/5

What do you like best about SQL Compare?

Most helpful feature about Redgate SQL Compare tool is that it enables comparison of different tables and datasets across multiple databases, saving a lot of time in identifying differences and discrepancies. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Downside of using the Redgate SQL Compare tool is that there is a learning curve to understand how to effectively use this tool, and it is not very intuitive. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Compare:

It is worth understanding and learning how to use this tool as it saves a ton of time over time and prevents erroneous data comparisons once you invest the time and effort to learn it. Review collected by and hosted on G2.com.

What problems is SQL Compare solving and how is that benefiting you?

I use this tool every now and then to compare huge datasets in tables across multiple databases within the same environments as well as across test and production environments to sync the data across all servers and databases. This saves a lot of time as it would be very painful to do this manually without the use of this tool and also allows room for user error otherwise. Review collected by and hosted on G2.com.