Get the most out of Flyway v7 - Sign up for our webinar on the Redgate Hub ▶ Watch now

SQL Migration Suffixes

Description

Comma-separated list of file name suffixes for SQL migrations.

SQL migrations have the following file name structure: prefixVERSIONseparatorDESCRIPTIONsuffix, which using the defaults translates to V1_1__My_description.sql

Multiple suffixes (like .sql,.pkg,.pkb) can be specified for easier compatibility with other tools such as editors with specific file associations.

Default

.sql

Usage

Commandline

./flyway -sqlMigrationSuffixes=".sql,.pkg,.pkb" info

Configuration File

flyway.sqlMigrationSuffixes=.sql,.pkg,.pkb

Environment Variable

FLYWAY_SQL_MIGRATION_SUFFIXES=.sql,.pkg,.pkb

API

Flyway.configure()
    .sqlMigrationSuffixes(".sql,.pkg,.pkb")
    .load()

Gradle

flyway {
    sqlMigrationSuffixes = '.sql,.pkg,.pkb'
}

Maven

<configuration>
    <sqlMigrationSuffixes>.sql,.pkg,.pkb</sqlMigrationSuffixes>
</configuration>