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

Schemas

Description

Comma-separated case-sensitive list of schemas managed by Flyway.

Flyway will attempt to create these schemas if they do not already exist, and will clean them in the order of this list. If Flyway created them, then the schemas themselves will be dropped when cleaning.

If defaultSchema is not specified, the first schema in this list also acts as the default schema.

Usage

Commandline

./flyway -schemas="schema1,schema2" info

Configuration File

flyway.schemas=schema1,schema2

Environment Variable

FLYWAY_SCHEMAS=schema1,schema2

API

Flyway.configure()
    .schemas("schema1,schema2")
    .load()

Gradle

flyway {
    schemas = ['schema1', 'schema2']
}

Maven

<configuration>
    <schemas>
        <schema>schema1</schema>
        <schema>schema2</schema>
    </schemas>
</configuration>