Redgate Flyway

For PostgreSQL users - where are your DBs hosted?

Check DryRun

Description

The check -dryrun command generates a dry run script. This is equivalent to a dry run script generated via migrate or prepare. The flag exists for the convenience of generating all pre-deployment reports in a single command invocation.

Usage examples

flyway check -dryrun

Parameters

Optional

Parameter Namespace Description
dryRunOutput (root) The output file path.
workingDirectory (root) The directory to consider the current working directory. All relative paths will be considered relative to this.
{environment parameters} (root) Environment configuration for the source and/or target environments.

Universal commandline parameters are listed here.

Other relevant configuration settings are listed here. The settings from these sections can be set as parameters on the check -dryrun command:

  • General settings
  • Migration location and naming settings
  • Migration reading settings
  • Migration execution settings
  • Flyway schema history settings
  • Placeholders
  • Settings in database-specific namespaces
  • Settings in secrets management namespaces

JSON output format

{
  "htmlReport": "report.html",
  "jsonReport": "report.json",
  "individualResults": [
    {
      message: null,
      stackTrace: null,
      sql: "SELECT 1;",
      timestamp: "2022-07-22T08-08-33Z",
      database: "testdb",
      operation: "dryrun",
      flywayVersion: undefined,
      warnings: undefined,
    }
  ]
 }

Error codes

This command can produce the following error codes:


Didn't find what you were looking for?