5 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100
15 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.4 out of 100

Likelihood to Recommend

dbForge Data Compare for MySQL

Data Compare covers two main use cases for us:
1) Keep data in sync between our development, test, and staging environments. When a full database import isn't practical, we will use Data Compare to sync data for key tables. We use this for configuration tables as well as operational test data.
2) Troubleshoot prod issues. When we have trouble reproducing user issues, Data Compare helps us compare our test environment data vs prod environment data to identify problems.
Anthony Aziz | TrustRadius Reviewer

Redgate SQL Data Compare

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.
Luca Campanelli | TrustRadius Reviewer

Feature Rating Comparison

Database Development

dbForge Data Compare for MySQL
8.0
Redgate SQL Data Compare
7.4
Database change management
dbForge Data Compare for MySQL
8.0
Redgate SQL Data Compare
8.7
Version control tools
dbForge Data Compare for MySQL
Redgate SQL Data Compare
7.0
Test data generation
dbForge Data Compare for MySQL
Redgate SQL Data Compare
6.3
Performance optimization tools
dbForge Data Compare for MySQL
Redgate SQL Data Compare
7.0
Schema maintenance
dbForge Data Compare for MySQL
Redgate SQL Data Compare
8.0

Database Administration

dbForge Data Compare for MySQL
Redgate SQL Data Compare
7.7
User management
dbForge Data Compare for MySQL
Redgate SQL Data Compare
6.0
Database security
dbForge Data Compare for MySQL
Redgate SQL Data Compare
7.0
Database status reporting
dbForge Data Compare for MySQL
Redgate SQL Data Compare
10.0
Change management
dbForge Data Compare for MySQL
Redgate SQL Data Compare
7.9

Pros

dbForge Data Compare for MySQL

  • Compare entire or subset of MySQL tables between databases
  • Configure comparison rules
  • Sync data between compared databases depending on differences
  • Save comparison rules for reuse and sharing
  • Break down differences between missing/new records, or different records
  • See differences highlighted per field
  • Execute sync immediately, or save as an SQL script file
  • Command-line tool that can be used to add comparisons to deploy scripts
Anthony Aziz | TrustRadius Reviewer

Redgate SQL Data Compare

  • 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.
Richard Davies | TrustRadius Reviewer

Cons

dbForge Data Compare for MySQL

  • Comparison can be very slow on large datasets.
  • Comparing records that are *different* is clunky, especially for tables with many fields.
Anthony Aziz | TrustRadius Reviewer

Redgate SQL Data Compare

  • Redgate SQL Data Compare is a bit slow for large text data comparison between the text fields of tables when compared to enabling SQL search engine.
  • Sometimes some characters haven't been identified and compared when comparing data between two environments.
  • It needs better customer support for utilizing the tool, and cost factor also matter.
Anonymous | TrustRadius Reviewer

Support Rating

dbForge Data Compare for MySQL

No score
No answers yet
No answers on this topic

Redgate SQL Data Compare

Redgate SQL Data Compare 10.0
Based on 2 answers
Redgate is always fast to respond to any tickets I submit and provide fixes for any issues rapidly.
Anonymous | TrustRadius Reviewer

Alternatives Considered

dbForge Data Compare for MySQL

We haven't tried any other tools that do comparisons like Data Compare does. Our method prior to buying this tool was to manually run queries on each database and compare the output using text compare or by eye.
Anthony Aziz | TrustRadius Reviewer

Redgate SQL Data Compare

We have used Symantecs Database Agents for Backup Exec and Veeam's Database Backup products. Symantec does not stack up well as compared to Redgate. Veeam is a considerable contender with their SQL Server Explorer. In some scenarios I would prefer to use VEEAM over Redgate, but Redgate is a very stable product that is extremely useful.
Michael Jipping | TrustRadius Reviewer

Return on Investment

dbForge Data Compare for MySQL

  • Improve developer productivity by making data syncing quicker and easier.
  • Reduce risk of deployment by ensuring data is in sync.
  • Reduce issue resolution time by making "bad data" investigations quicker.
Anthony Aziz | TrustRadius Reviewer

Redgate SQL Data Compare

  • An incredible gain in terms of time
  • Speed in compiling the data update scripts
  • Ease in comparing tables
Luca Campanelli | TrustRadius Reviewer

Pricing Details

dbForge Data Compare for MySQL

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Redgate SQL Data Compare

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

dbForge Data Compare for MySQL
10.0
Redgate SQL Data Compare
9.5

Support Rating

dbForge Data Compare for MySQL
Redgate SQL Data Compare
10.0

Add comparison