Best Software for 2025 is now live!
View the Winners
SQL Compare
Editedit
SQL Compare
By Redgate Software
Show rating breakdown
4.4 out of 5 stars
See all 28 SQL Compare reviews
Save to My Lists
Claimed
Claimed
This profile has been claimed by SQL Compare, but it has limited features.
Do you work at SQL Compare? Upgrade your plan to update branding and connect with profile visitors!

Top Rated SQL Compare Alternatives

Studio 3T
(186)
4.6 out of 5
Visit WebsiteNew Tab
SponsoredYou’re seeing this ad based on the product’s relevance to this page. Sponsored content does not receive preferential treatment in any of G2’s ratings.
Liquibase
(27)
4.5 out of 5
dbForge Studio for MySQL
(100)
4.7 out of 5
See all SQL Compare Alternatives

SQL Compare Reviews & Product Details

Editadmin

SQL Compare Overview

Editedit
What is SQL Compare?

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/

SQL Compare Details
Discussions
SQL Compare Community
Languages Supported
English
Show LessShow More
Product Description

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

Seller Details
Seller
Redgate Software
Year Founded
1999
HQ Location
Cambridge, United Kingdom
Twitter
@redgate
17,809 Twitter followers
LinkedIn® Page
www.linkedin.com
573 employees on LinkedIn®
Description

Redgate offers end-to-end Database DevOps to help organizations streamline software development and get value from their data faster.Redgate’s portfolio of solutions helps organizations reliably solve the complex challenges of database management across the DevOps lifecycle on any database, anywhere. We make life easier for IT leaders, development and operations teams, increasing efficiency, reducing errors and safeguarding business-critical data.Together, the above make up Redgate’s company boilerplate for press releases. We also include the below:More than
00,000 people globally, including 9
% of the Fortune 100, trust Redgate to deliver ingeniously simple software.

TP
Overview Provided by:
Tey Peryie

Recent SQL Compare Reviews

Verified User
U
Verified UserMid-Market (51-1000 emp.)
0.0 out of 5
"Red Gate Compare fails with a spurious error"
Its great when it works. But it's useless when it doesn't.
Read more
MS
Matthew S.Small-Business (50 or fewer emp.)
5.0 out of 5
"SQL Compare, best tool out there!"
Easy to compare objects between databases, compare procs, tables, triggers or permissions and sync them up easily. Used regularly to promote chang...
Read more
Verified User
A
Verified UserMid-Market (51-1000 emp.)
5.0 out of 5
"I use it daily"
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...
Read more

SQL Compare Pricing

SQL Compare
Starting at $282.00
1 user Per Year
See SQL Compare pricing
Security Badge
This seller hasn't added their security information yet. Let them know that you'd like them to add it.
0 people requested security information

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.
Answer a few questions to help the SQL Compare community
Have you used SQL Compare before?
Yes

28 SQL Compare Reviews

4.4 out of 5
The next elements are filters and will change the displayed results once they are selected.
Search reviews
Popular Mentions
The next elements are radio elements and sort the displayed results by the item selected and will update the results displayed.
Hide FiltersMore Filters
The next elements are filters and will change the displayed results once they are selected.
  • Company SizeExpand/Collapse Company Size Filter
  • User RoleExpand/Collapse User Role Filter
  • CategoryExpand/Collapse Category Filter
  • IndustryExpand/Collapse Industry Filter
  • RegionExpand/Collapse Region Filter
The next elements are filters and will change the displayed results once they are selected.
  • Sort By:
    G2 Sort
28 SQL Compare Reviews
4.4 out of 5
  • Sort By:
    G2 Sort
28 SQL Compare Reviews
4.4 out of 5
  • Sort By:
    G2 Sort

Overall Review Sentiment for SQL CompareQuestion

Time to Implement
<1 day
>12 months
Return on Investment
<6 months
48+ months
Ease of Setup
0 (Difficult)
10 (Easy)
Log In
Want to see more insights from verified reviewers?
Log in to view review sentiment.
G2 reviews are authentic and verified.
Here's how.
Verified User in Wholesale
UW
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
(Original )Information
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.

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

detecting changes between 2 production databases. Review collected by and hosted on G2.com.

Show More
Show Less
Helpful?
Share
Admin Approval Link
MS
Network Operator
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: Organic
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.

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

Code promotion, tracking down discrepancies, easy object snapshot comparison to what is live Review collected by and hosted on G2.com.

Show More
Show Less
Helpful?
Share
Admin Approval Link
CD
IT Senior Business Analyst
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
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.

Show More
Show Less
Helpful?
Share
Admin Approval Link
Verified User in Health, Wellness and Fitness
AH
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: Organic
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.

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

It speeds up change management between development, test and production environments. Review collected by and hosted on G2.com.

Show More
Show Less
Helpful?
Share
Admin Approval Link
RR
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic
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.

Show More
Show Less
Helpful?
Share
Admin Approval Link
Verified User in Gambling & Casinos
UG
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: Organic
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.

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

Finding the schema difference and generate the script change. Review collected by and hosted on G2.com.

Show More
Show Less
Helpful?
Share
Admin Approval Link
Verified User in Logistics and Supply Chain
AL
Mid-Market(51-1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
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.

Show More
Show Less
Helpful?
Share
Admin Approval Link
Verified User in Hospital & Health Care
UH
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Verified Current User
Review source: G2 invite
Incentivized Review
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.

Show More
Show Less
Helpful?
Share
Admin Approval Link
IM
Information System Engineer
Small-Business(50 or fewer emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about SQL Compare?

It's super fast, accurate, and simple. Saved hours of development using it! Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Price is a bit expensive, it should be an option for small business Review collected by and hosted on G2.com.

Recommendations to others considering SQL Compare:

Try it! Review collected by and hosted on G2.com.

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

I have a tenant database architecture, and RedGate helps me to compare and share configuration info between all of them. Review collected by and hosted on G2.com.

Show More
Show Less
Helpful?
Share
Admin Approval Link
Verified User in Information Technology and Services
UI
Enterprise(> 1000 emp.)
More Options
Validated Reviewer
Review source: G2 invite
Incentivized Review
What do you like best about SQL Compare?

Redgate approach to filtering is generally easier to manage. Review collected by and hosted on G2.com.

What do you dislike about SQL Compare?

Redgate scripts do not support SQLCMD variable syntax. Review collected by and hosted on G2.com.

Recommendations to others considering SQL Compare:

Just use it if you want model based source control solution. Review collected by and hosted on G2.com.

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

I had a team of 12 members, Sometimes its too heavy load on us to compare huge database objects, this problem is solved with Redgate Review collected by and hosted on G2.com.

Show More
Show Less
Helpful?
Share
Admin Approval Link
SQL Compare Categories on G2
Database Comparison
Database Comparison

SQL Compare Comparisons

Compare SQL Compare vs. Liquibase
Compare SQL Compare vs. Liquibase
SQL CompareVSLiquibase
Compare dbForge vs. SQL Compare
Compare dbForge vs. SQL Compare
SQL CompareVSdbForge
Compare Snowflake vs. SQL Compare
Compare Snowflake vs. SQL Compare
SQL CompareVSSnowflake
Compare SQL Compare ratings to similar products

Explore More

Cloud Storage Security
Google Cloud Speech-to-Text reviews
Medium of Exchange
Household Employee
Order Fulfillment
Google Cloud Translation API reviews
Best Payroll Software
Out of Office Messages
Quasi Contract
SQL Compare