Redgate SQL Data Compare

Redgate SQL Data Compare

About TrustRadius Scoring
Score 8.5 out of 100
Redgate SQL Data Compare

Overview

Recent Reviews

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 Data 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?

Alternatives Pricing

What is DBeaver?

DBeaver is a universal database management and development tool from the company of the same name. DBeaver is available free through its community edition (Apache 2.0 license) and through commercial editions, available with upgrades and customer support.

Sorry, this product's description is unavailable

Features Scorecard

No scorecards have been submitted for this product yet..

Product Details

What is Redgate SQL Data Compare?

Redgate SQL Data Compare Videos

SQL Data Compare Running on Google SQL Database
SQL Data Compare Running on AWS RDS

Redgate SQL Data Compare Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

Comparisons

View all alternatives

Reviews and Ratings

 (23)

Ratings

Reviews

(1-4 of 4)
Companies can't remove reviews or game the system. Here's why
Score 10 out of 10
Vetted Review
Verified User
Review Source
I primarily use Redgate SQL Data Compare when troubleshooting issues to determine what has changed in a database between two times. It is great for ad-hoc troubleshooting, then recovering from the issue.
  • Provides many options for setting the comparison key
  • Provides flexibility about what you are comparing (database, backup, scripts)
  • Makes it easy to filter down to just what you are looking for
  • Would be cool if it could read transaction logs to find what caused the change
I think every DBA needs a tool like Redgate SQL Data Compare for day-to-day work and troubleshooting of issues.
Redgate is always fast to respond to any tickets I submit and provide fixes for any issues rapidly.
Richard Davies | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
My small web development team uses Redgate SQL Data Compare to help us manage our SQL databases across different environments (development, QA, and production, etc.). It eliminates the tedious and manual task of comparing databases and synchronizing them across these different environments.
  • Simple and easy comparison of database data. Differences can be copied or synced from one database to another with a click of a button.
  • You can save "projects" so that you can easily rerun a previous comparison whenever you need to.
  • It has a very simple, easy to learn interface. I've never needed to read any documentation or watch any tutorials in order to figure out how to do something.
  • It would be cool if you could write your own custom SQL query to use for selecting what data you want to compare.
  • I haven't looked to see if there's a way to do this or not, but it would be nice if you could programmatically run a saved project to sync data from one database to another.
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.
I don't remember if I've ever needed to use their support.
Luca Campanelli | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
I actually use Redgate Data Compare every day a long time, this software used with his "brother" SQL Compare (used to compare DB structures) forms the winning pair for fast and simple control of DB and data structures (intended for each record, column by column) between different environments of development.
  • Very fast data comparison even on complex tables
  • Simple and intuitive use
  • Speed in compiling data alignment scripts
  • Requires version upgrade if you upgrade SQl Server
  • Some features or additional feature are hidden among the option's flags
  • License fee slightly high
If you plan to use Redgate Data Compare to automate data change between tables or SCD or similar, this is not the software that is right for you, Data Compare is a software that performs simply (but in an optimal manner) the comparison of data between tables of different databases on different environments or clone or mirror databases even on the same environment or server. Once the data is compared, you can select or deselect each line you want to update and then have the data alignment script prepared for it.
Michael Jipping | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source
Redgate is used by the entire organization to Backup and Recover Microsoft SQL Servers hosted on HyperV and Physical Hosts.

It solved our business need for solid SQL Server Backups, Retention Policies, and De-duplication via Advanced Compression. It also provided a great Centralized Management of the SQL Server Environment. I would highly recommend it.
  • It provided a Great Centralized Management Console. User can go to the Console to manage all of their Redgate Licenses and also configure SQL Server Backups.
  • It does an excellent job at managing the SQL Backup and Compressing the backup file to allow for easy transport to DR Locations.
  • It has great options for SQL Server Backup Jobs including copying to secondary storage locations.
  • Better License Management would be an improvement. Currently no way to manage your licenses without contacting your representative.
  • Possibly better testing of backups would an improvement. Ability to restore files in a Sandbox would be a great feature.
Redgate SQL Backup is well suited for use in large and small organizations. It is scalable to needs of a large organization as they expand their footprint. Some of their other products such as the SQL Toolbelt and the Redgate SQL Monitor are also extremely beneficial. Organizations with low bandwidth between interconnects will benefit from the compression feature.