Redgate Flyway

Info

Description

Prints the details and status information about all the migrations.

See Flyway Schema History Table for more information.

Usage examples

Info via command line

flyway info -infoSinceDate="01/12/2020 13:00"

Info via Maven

mvn flyway:info

Info via Gradle

gradle flywayInfo

Parameters

Universal commandline parameters are listed here.

All relevant configuration settings are listed here. The settings from these sections can be set as parameters on the info command:

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

It is also possible to set environment settings as parameters.

The following parameters are also available:

Parameter Description
infoSinceDate Limits info to show only migrations applied after this date, and any pending migrations. Must be in the format dd/MM/yyyy HH:mm (e.g. 01/12/2020 13:00)
infoUntilDate Limits info to show only migrations applied before this date. Must be in the format dd/MM/yyyy HH:mm (e.g. 01/12/2020 13:00)
infoSinceVersion Limits info to show only migrations greater than or equal to this version, and any repeatable migrations. (e.g 1.1)
infoUntilVersion Limits info to show only migrations less than or equal to this version, and any repeatable migrations. (e.g. 1.1)
infoOfState Limits info to show only migrations of the provided states. This is a case insensitive, comma-separated list. The valid states can be found at Migration States.
migrationIds Suppresses all other output and displays a comma-separated list of migration versions for versioned migrations and descriptions for repeatable migrations. This is equivalent to the expected input to cherryPick

All parameters are optional, although a target environment must be configured or passed in.

JSON output format

{
  "schemaVersion": null,
  "schemaName": "public",
  "migrations": [
    {
      "category": "Versioned",
      "version": "1",
      "description": "first",
      "type": "SQL",
      "installedOnUTC": "",
      "state": "Pending",
      "undoable": "No",
      "filepath": "C:\\flyway\\sql\\V1__first.sql",
      "installedBy": "",
      "executionTime": 0
    },
    {
      "category": "Repeatable",
      "version": "",
      "description": "repeatable",
      "type": "SQL",
      "installedOnUTC": "",
      "state": "Pending",
      "undoable": "",
      "filepath": "C:\\flyway\\sql\\R__repeatable.sql",
      "installedBy": "",
      "executionTime": 0
    }
  ],
  "allSchemasEmpty": false,
  "flywayVersion": "11.3.2",
  "database": "testdb",
  "warnings": [],
  "operation": "info"
}

Didn't find what you were looking for?