1 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.1 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 Schema Compare for MySQL

We use Schema Compare for two main scenarios:
1) Creating schema upgrade scripts to use when deploying. As our schema grows and changes, we want to tie these changes to a specific build so related code changes will be deployed along with side database schema changes. We do this by using Schema Compare to compare the modified dev database to a stable staging environment database, and then save a sync script. We can then modify that script as needed (perhaps with some update statements for migration), and include that in the deploy artifacts, which our deployment will automatically run.
2) Syncing the developer database with changes from other developers, matching prod schema, or otherwise managing dev database instances.
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 Schema Compare for MySQL
9.1
Redgate SQL Data Compare
7.4
Schema maintenance
dbForge Schema Compare for MySQL
9.1
Redgate SQL Data Compare
8.0
Database change management
dbForge Schema Compare for MySQL
9.1
Redgate SQL Data Compare
8.7
Version control tools
dbForge Schema Compare for MySQL
Redgate SQL Data Compare
7.0
Test data generation
dbForge Schema Compare for MySQL
Redgate SQL Data Compare
6.3
Performance optimization tools
dbForge Schema Compare for MySQL
Redgate SQL Data Compare
7.0

Database Administration

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

Pros

dbForge Schema Compare for MySQL

  • Compare entire or subset of MySQL tables between databases.
  • Configure comparison rules.
  • Automatically sync schemas between databases on a per-table basis.
  • Save comparison rules for reuse and sharing.
  • 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 Schema Compare for MySQL

  • When viewing a table comparison, data is presented in a text-based format (such as a diff viewer). This is inferior to a more structured view like dbForge Data Compare has.
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 Schema 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 Schema 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 export the entire schema to a text file and use diff tools to compare differences.
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 Schema Compare for MySQL

  • Improve developer productivity by making schema syncing quicker and easier.
  • Reduce risk of deployment by ensuring schema changes will be applied appropriately.
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 Schema 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 Schema Compare for MySQL
9.1
Redgate SQL Data Compare
9.4

Support Rating

dbForge Schema Compare for MySQL
Redgate SQL Data Compare
10.0

Add comparison