Description

Flyway Enterprise

The check -drift command checks a target environment for drift, in order to ensure that it is still in the expected state for running deployments.

Deployment can be aborted if drift is detected, and a report will be generated.

The report is generated using snapshots .

See Drift analysis for more information.

Usage examples

Generating report based upon a snapshot embedded in the target database

flyway check -drift -environment="Production"

The comparison which underlies the report is generated from the specified snapshot and a target database. Note that if you configure your pipeline to check for drift ahead of doing a deployment, the very first time you do a deployment, there won't be a snapshot in the database to use for the drift check. In this scenario, Flyway will succeed but log a warning, so that the first deployment doesn't have to be treated as a special case.

Generating report based upon a snapshot located on the filesystem

flyway check -drift -deployedSnapshot="C:\snapshot1.json" -environment="Production"

The comparison which underlies the report is generated from the specified snapshot and a target database.

Generating report based upon a target environment

flyway check -drift -buildEnvironment="build" -environment="production"

This approach captures a snapshot of the updated build database, and uses this as the basis for the comparison against the target database which underlies the report. This approach will detect all drift from what is in the migrations, regardless of whether it has occurred since the last deployment or was pre-existing.

Generating report based upon applied migrations

flyway info -infoOfState="success,out_of_order" -migrationIds > appliedMigrations.txt
flyway check -drift -buildEnvironment="build" -appliedMigrations="$(cat appliedMigrations.txt) -environment="production"

This approach captures a snapshot of the updated build database, and uses this as the basis for the comparison against the target database which underlies the report. This assumes that the migrations deployed to the target environment represent the full state of that database at the point of last deployment.

Parameters

Optional

Universal commandline parameters are listed here.

Settings from the following sections of the Flyway namespace can be specified in relation to database connections:

• General settings
• Settings in database-specific namespaces
• Settings in secrets management namespaces

When a build environment is used, settings from the following sections of the Flyway namespace can also be set:

• Migration location and naming settings
• Migration reading settings
• Migration execution settings
• Flyway schema history settings
• Placeholders

Note:

• Drift detection will not interrupt the execution of subsequent Flyway verb operations if they are chained. This means that even if a failOnDrift error occurs, Flyway will continue processing the remaining verb operations. For this reason, it is recommended to run subsequent Flyway verbs separately.

JSON output format

{
  "htmlReport": "report.html",
  "jsonReport": "report.json",
  "individualResults": [
    {
      message: null,
      stackTrace: null,
      onlyInSource: [],
      onlyInTarget: [],
      differences: [
        {
          name: "Table_1",
          schema: "dbo",
          objectType: "Table",
          definitionBefore: "CREATE TABLE Table_1 (id text)",
          definitionAfter: "CREATE TABLE Table_1 (different_id text)",
        },
      ],
      timestamp: "2022-07-22T08-08-33Z",
      database: "testdb",
      operation: "drift",
      flywayVersion: undefined,
      warnings: undefined,
    }
  ]
 }

Error codes

This command can produce the following error codes:

• Generic error codes
• Check error codes