Redgate Summit – The Database DevOps Transformation Watch now
PASS Data Community Summit logo

PASS Data Community Summit

A hybrid conference in Seattle and online

15-18 November

Flyway Documentation

This documentation site is not updated. The new documentation can now be found on documentation.red-gate.com

Poll

Ignore Migration Patterns

Description

Ignore migrations during validate and repair according to a given list of patterns.

Only Missing migrations are ignored during repair.

Patterns

Patterns are of the form type:status with * matching type or status.

type must be one of (case insensitive):

status must be one of (case insensitive):

  • Missing
  • Pending
  • Ignored
  • Future
  • * (will match any of the above)

For example, the pattern to ignore missing repeatables is:

repeatable:missing

Patterns are comma seperated. For example, to ignore missing repeatables and pending versioned migrations:

repeatable:missing,versioned:pending

The * wild card is also supported, thus:

*:missing

will ignore missing migrations no matter their type and:

repeatable:*

will ignore repeatables regardless of their state.

Default

*:future

Usage

Commandline

./flyway -ignoreMigrationPatterns="repeatable:missing" validate

Configuration File

flyway.ignoreMigrationPatterns="repeatable:missing"

Environment Variable

FLYWAY_IGNORE_MIGRATION_PATTERNS="repeatable:missing"

API

Flyway.configure()
    .ignoreMigrationPatterns("repeatable:missing")
    .load()

Gradle

flyway {
    ignoreMigrationPatterns = ['repeatable:missing']
}

Maven

<configuration>
    <ignoreMigrationPatterns>
        <ignoreMigrationPattern>repeatable:missing</ignoreMigrationPattern>
    </ignoreMigrationPatterns>
</configuration>

Unsetting the value

By default, future migrations are ignored. You can unset this by assigning an empty string to ignoreMigrationPatterns

For example, in your configuration file you would add:

flyway.ignoreMigrationPatterns=