Redgate Flyway

For PostgreSQL users - where are your DBs hosted?

Flyway Check Drift On Migrate Setting

Redgate Flyway Community

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

./flyway migrate -email="foo.bar@red-gate.com" -token="1234ABCD" -publishResult=true -checkDriftOnMigrate=true

TOML Configuration File

[flyway]
email="foo.bar@red-gate.com"
token="1234ABCD"
publishResult=true
checkDriftOnMigrate=true

Environment Variable

FLYWAY_EMAIL=foo.bar@red-gate.com
FLYWAY_TOKEN=1234ABCD
FLYWAY_PUBLISH_RESULT=true
FLYWAY_CHECK_DRIFT_ON_MIGRATE=true

Didn't find what you were looking for?