An indispensable tool for comparing and syncing data in Microsoft SQL databases.
Richard Davies | TrustRadius Reviewer
November 05, 2019

An indispensable tool for comparing and syncing data in Microsoft SQL databases.

Score 10 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Redgate SQL Data Compare

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.
  • It's reduced errors and bugs associated with deploying new application features and forgetting to apply required database changes (or incorrectly applying them).
  • It's made deploying new features a quicker task, eliminating the often laborious task of synchronizing data across databases.
  • These sometimes complex queries and operations can easily be performed by any developer and don't require the involvement of a database administrator to perform.
I haven't needed to try any other similar products like Redgate SQL Data Compare.
I don't remember if I've ever needed to use their support.

Do you think Redgate SQL Data Compare delivers good value for the price?

Yes

Are you happy with Redgate SQL Data Compare's feature set?

Yes

Did Redgate SQL Data Compare live up to sales and marketing promises?

Yes

Did implementation of Redgate SQL Data Compare go as expected?

Yes

Would you buy Redgate SQL Data Compare again?

Yes

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.

Redgate SQL Data Compare Feature Ratings

Version control tools
Not Rated
Test data generation
5
Performance optimization tools
Not Rated
Schema maintenance
Not Rated
Database change management
8
User management
Not Rated
Database security
Not Rated
Database status reporting
Not Rated
Change management
5