It's been two months since this profile received a new review

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

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

Liquibase

4.5/5

(26)

dbForge Studio for MySQL

View All Alternatives

SQL Compare Media

SQL Compare Demo - Compare SQL Server schema changes from dev, to test, to production

Compare SQL Server database schemas, large or small, and including Temporal Tables, with advanced filtering of database objects. You can explore what’s changed in each database object, down to individual lines of SQL. When you’re ready to deploy, you can create an error-free deployment script ...

SQL Compare Demo - Deploy with zero errors

SQL Compare scripts dependencies in your database in the right order, to make sure deployment is successful. You get notifications about any issues, such as data loss, before you deploy.

SQL Compare Demo - Deploy changes directly

Migrate individual schema differences, a selection of them, or all of them. Build sophisticated rules to selectively limit what to deploy. You can run deployments directly from the UI or command line, save deployment scripts for later use, or automate your deployments using SQL Change Autom...

SQL Compare Demo - Find and fix problems in production

To fix errors in your production database, compare it to a backup, scripts in source control, or a database snapshot. You can deploy single objects to fix the issue fast. If you need to fix static data, use SQL Data Compare to deploy changes without the need for full database recovery.

SQL Compare Reviews (28)

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?

Its 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 with out 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 is more differences then 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 dut 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 seperate computer that the main server. When i am ready to upgrade the server, the product gives me a path to do so. I will ususally replicate the server database first the do the comparison with both this tool and the data Compare tool. The later allows be 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 its enables to be compare different tables and datasets across multiple databases and saves a lot of time to figure out 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 be able to understand how to effectively use this tool and 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 saves erroneous data comparisons once you put in the time and effort to learn to use this tool. 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 environment 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.