Published 16 November 2022
Validates the applied migrations against the available ones.
Validate helps you verify that the migrations applied to the database match the ones available locally.
This is very useful to detect accidental changes that may prevent you from reliably recreating the schema.
Validate works by storing a checksum (CRC32 for SQL migrations) when a migration is executed. The validate mechanism checks if the migration locally still has the same checksum as the migration already executed in the database.
Custom validation rules
As the lifetime of a project increases, there will inevitably be hotfixes, deleted migrations and other changes that break the conventions of Flyway's validation.
In these cases you need a way to tell Flyway that these migrations are valid. Flyway Teams Edition provides the flexibility to do this.
Learn more about custom validate rules
See configuration for validate specific configuration parameters.
Didn't find what you were looking for?
- Visit the Redgate forum
- Contact Support