Tutorial - Checking for drift in static data
Published 04 February 2026
The current drift detection only checks for drift in schema objects.
Flyway Enterprise comes with SQL Data Compare and Data Compare for Oracle. These tools and their docker images can be used to check for drift in static data as part of an automated pipeline as well.
One of our Solution Engineers has created an example using SQL Data Compare for how this could work. See the details at https://github.com/MrTyRedgate/DataCompareReport.
If you'd like this feature to be built into Redgate Flyway, vote on this suggestion.