We are happy to announce the availability of a drift check for Flyway Community, available in Flyway versions 10.20.1 and later. The drift check is currently in preview and is compatible with PostgreSQL versions 12 to 17.
Database drift is the unintentional divergence of a database schema from its version-controlled state, often due to direct changes made outside the standard deployment process.
Drift is detected by comparing the state of your PostgreSQL schema after your last migration and before your next migration scripts have been applied and will tell you if out-of-process changes have occurred in between those two states. You will be able to see information regarding the database objects that have drifted in a drift report within Flyway Pipelines
Visit https://flyway.red-gate.com/ for instructions on how to configure the drift check and download the latest version of Flyway.
The following PostgreSQL variants are also supported in Flyway Pipelines: EnterpriseDB Advanced Server, EnterpriseDB Extended Server, Amazon RDS for PostgreSQL, Google Cloud for PostgreSQL, Azure PostgreSQL - Flexible Server, Azure PostgreSQL - Single Server, Aurora PostgreSQL and YugabyteDB (v2.4 and above). Full details of supported versions can be found here
Flyway is a tool used for managing database migrations. It helps you version control your database schema, ensuring that changes are applied consistently across different environments.
Flyway Pipelines is a tool used to improve the visibility and observability of your database deployments across your organization.