Redgate SQL Compare

Redgate SQL Compare

About TrustRadius Scoring
Score 8.8 out of 100
Redgate SQL Compare

Overview

Recent Reviews

Fantastic time saving SQL tool

8 out of 10
May 03, 2021
We use Redgate SQL compare to quickly and easily compare date between or development, test, staging and production environments. It allows …
Continue reading

Popular Features

View all 9 features

Schema maintenance (9)

9.0
90%

Database change management (11)

8.7
87%

Change management (8)

8.4
84%

User management (5)

7.8
78%

Video Reviews

Leaving a video review helps other professionals like you evaluate products. Be the first one in your network to record a review of Redgate SQL Compare, and make your voice heard!

Pricing

View all pricing
N/A
Unavailable

Sorry, this product's description is unavailable

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting / Integration Services

Would you like us to let the vendor know that you want pricing?

1 person want pricing too

Alternatives Pricing

What is dbForge Studio?

dbForge Studio is provided by Devart and is a universal front-end client for database management, administration and development. Devart's GUI tool provides utilities to compare, synchronize, and back up databases (e.g. MySQL, Oracle, SQL Server, PostgreSQL, etc.) with scheduling, and includes the…

What is Toad Database Developer Tools?

Toad by Quest is a database management toolset that database developers, administrators and data analysts use to simplify workflows, create code free from defects, automate frequent or repetitive processes, and minimize risks. Editions include Toad for Oracle, which automates administration tasks…

Features Scorecard

Database Development

7.2
72%

Database Administration

7.2
72%

Product Details

What is Redgate SQL Compare?

Redgate SQL Compare Video

Overview of SQL Compare

Redgate SQL Compare Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Comparisons

View all alternatives

Reviews and Ratings

 (48)

Ratings

Reviews

(1-11 of 11)
Companies can't remove reviews or game the system. Here's why
Steven Gockley, MBA, MCSA | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source
We have actually been able to use this not only manually but in our DevOps and release process, we have been able to use the SDK to add automation so certain business scenarios we can accomplish with very little effort. We are in an AWS environment with multiple AZs and Active Directories and this tool handles it with no problem. We ensure we have an available endpoint and it is easy to deploy no matter where the DB's are.
Score 8 out of 10
Vetted Review
Verified User
Review Source
Well suited for
- Deployment of db schemas
- Comparison of data between environments
- Easy creation of SQL scripts
- Allows easy synchronization of databases
- Allows you to easily create deployment scripts.

Features such as these have offered massive time savings for our development group. Highly recommend this product.

Score 8 out of 10
Vetted Review
Verified User
Review Source
Redgate is just a massive timesaving tool for releasing changes from our dev to live platforms. Being able to choose all the objects that need scripting out to alter, create, and drop statements with the click of a few buttons, taking into consideration all the dependencies, is brilliant. Coupled with that, the ability to review the differences along the way for last-minute issue spotting is hugely helpful.
Kevin R. Zakoski | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

We use SQL Compare to troubleshoot performance problems quite a bit since our data model is more like a template and not everything is 100% in sync and customization occurs between different client databases. We continually get pulled into performance issues and the developers will say Client A is performing different than Client B, why? Using SQL Compare, we usually find that one client was tuned and had indexes altered or added that weren't deployed to all clients or other objects weren't deployed correctly during the release.

On the other hand, since our data model practices allow client databases to drift I tried to create a new golden image by trying to compare multiple databases based on the same data model and found it to be a very difficult process to complete using SQL Compare. SQL Compare gave me too much information and doesn't allow enough filtering to eliminate a lot of the noise.

Score 9 out of 10
Vetted Review
Verified User
Review Source
Full disclosure, I'm a huge fan of Redgate and their SQL products and have been for years. Redgate SQL Compare is well suited anytime you have sets of data you want to compare or update. If you have large tables that you're trying to compare, however, it may take a very long time to compare. It also can take a little time to figure out the user interface — both in setting up the comparison and analyzing the results.
Richard Davies | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
If you maintain different copies of the same database (whether on the same server or on different servers) this is a must have tool. For example, in web development, it's common to have a development database, a testing/QA database, and a production database. This tool makes it easy to compare those different databases for any differences and synchronize changes and data between them. Now, when you deploy a new set of features to production, you can use this to deploy any accompanying database changes. However, if your application includes code that manages the database (for example, a new module or feature might include code to apply related database schema changes when it's installed), then this tool might not be necessary.
Aaron Smith | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
If you have to keep track of database changes that then need to be sent out to production databases, this is the tool for you! Never again will you need to write complicated scripts and try to catch all the changes that were made in the database between versions. It will even handle data if you need it to!
February 02, 2018

A must have for DBAs

Luca Campanelli | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
I use the software routinely, day after day, and I've been using it for 7 years, so I can 100% recommend this software because it never gave me a problem, it's always fast and responsive and it's simple. The classic case where a software in its simplicity does exactly what it should in the best way. The best use case is the comparison of environments before or after deployments.