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

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!
Aaron Smith | TrustRadius Reviewer

Feature Rating Comparison

Database Development

dbForge Schema Compare for MySQL
9.1
Redgate SQL Compare
9.0
Schema maintenance
dbForge Schema Compare for MySQL
9.1
Redgate SQL Compare
9.5
Database change management
dbForge Schema Compare for MySQL
9.1
Redgate SQL Compare
9.4
Version control tools
dbForge Schema Compare for MySQL
Redgate SQL Compare
9.9
Performance optimization tools
dbForge Schema Compare for MySQL
Redgate SQL Compare
7.1

Database Administration

dbForge Schema Compare for MySQL
Redgate SQL Compare
8.5
User management
dbForge Schema Compare for MySQL
Redgate SQL Compare
8.0
Database security
dbForge Schema Compare for MySQL
Redgate SQL Compare
8.0
Change management
dbForge Schema Compare for MySQL
Redgate SQL Compare
9.6

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 Compare

  • Simple and easy comparison of database schemas and 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 Compare

  • So far so good. I have to be honest, it's not a complicated application, and so far hasn't caused me any issues or to question the choices of the developers!
Anonymous | TrustRadius Reviewer

Support Rating

dbForge Schema Compare for MySQL

No score
No answers yet
No answers on this topic

Redgate SQL Compare

Redgate SQL Compare 10.0
Based on 2 answers
They have a great community website where you can search for answers but are also very responsive when it comes to direct support.
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 Compare

Honestly, I have never been interested in the usable alternatives. I have always been good to use it. The license cost after all has always been sustainable. I never had the idea of \ u200b \ u200bchanging it nor the need to look at other software. Also (always a redgate software) I use the Data Compare which is the "twin brother" for data check.
Luca Campanelli | 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 Compare

  • Saves me lots of time in doing database migration jobs right the first time.
  • Improves quality of releases, thus reducing rollbacks or stumbles in migrations that need to be be fixed urgently. This improves client and user satisfaction which usually indirectly equates to ROI -- happy customers are paying customers.
  • I get raises because I can deliver better work in my department.
Rob Cowart | 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 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 Compare
9.4

Support Rating

dbForge Schema Compare for MySQL
Redgate SQL Compare
10.0

Add comparison