Back to Flyway

Flyway Check Drift On Migrate Setting

documentation/Reference/Configuration/Flyway Namespace/Flyway Check Drift On Migrate Setting.md

latest1.5 KB
Original Source

{% include redgate.html %}

{% include preview.html %}

Description

Enables automatic drift checks on migrate. Requires an online authentication method to be configured. See Flyway Licensing for more details. Also requires publishResult to be set.

On migrate, a snapshot of your database schema is uploaded to Flyway Pipelines. Subsequent runs of migrate will compare the latest snapshot in Flyway Pipelines to your deployment target before script execution. If your deployment target is different from the schema snapshot in Flyway Pipelines, a drift alert will be issued to Flyway Pipelines.

Check drift on migrate is an alternative to the Check Drift command.

Type

Boolean

Default

false

Usage

Flyway Desktop

This can't be configured via Flyway Desktop, although it will be honoured.

Command-line

bash
./flyway migrate -email="[email protected]" -token="1234ABCD" -publishResult=true -checkDriftOnMigrate=true

TOML Configuration File

toml
[flyway]
email = "[email protected]"
token = "1234ABCD"
publishResult = true
checkDriftOnMigrate = true

Environment Variable

properties
[email protected]
FLYWAY_TOKEN=1234ABCD
FLYWAY_PUBLISH_RESULT=true
FLYWAY_CHECK_DRIFT_ON_MIGRATE=true