How comparison tools can help solve Flyway challenges
Published 12 May 2025
Redgate is excited to introduce two new tools, pgCompare and Schema Compare for MySQL.
Schema comparison tools can be used effectively alongside Flyway to solve key problems.
Keeping environments in sync
Environments (especially dev & test) will change over time, for example when fixes are made directly to the database rather than through migration scripts. Schema comparison tools can help to identify these changes, and can help revert the database schemas back to a consistent version.
Troubleshooting issues
Problems can arise in internal or customer environments that are caused by inconsistent database schemas. Schema comparison tools can help easily pinpoint these unexpected changes.
Pulling changes into migration scripts
If there are database changes have been made directly to dev or test environments that need to be scripted for inclusion in a migration script, by comparing these databases with a downstream database (eg production) you can identify the changes and create the diff SQL that can be subsequently copied into a migration script. 
These tools are currently in preview and we’d very much like you to try them out and let us know how to improve them.
