Info
Published 15 January 2025
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"
}