Redgate Flyway

This namespace contains the configurations specific to the Flyway engine.

General settings

Setting	Tier	Type	Description
`communityDBSupportEnabled`	Community	Boolean	Enables support for community databases.
`environment`	Community	String	The target environment.
`kerberosConfigFile`	Teams	String	The path to the your Kerberos configuration file.
`loggers`	Community	String array	Loggers to use.
`reportEnabled`	Community	Boolean	Whether to enable generating a report file.
`reportFilename`	Community	String	Filename for the report file.
`provisionMode`	Community	String	Use a specific provision mode for the target environment

Migration location and naming settings

Setting	Tier	Type	Description
`baselineMigrationPrefix`	Community	String	The file name prefix for baseline migrations.
`failOnMissingLocations`	Community	Boolean	Whether to fail if a location doesn't exist.
`jarDirs`	Community	String array	Directories containing JDBC drivers and Java-based migrations.
`locations`	Community	String array	Locations to scan recursively for migrations.
`repeatableSqlMigrationPrefix`	Community	String	The file name prefix for repeatable migrations.
`sqlMigrationPrefix`	Community	String	The file name prefix for versioned migrations.
`sqlMigrationSeparator`	Community	String	The file name separator for migrations.
`sqlMigrationSuffixes`	Community	String array	The file name suffixes for migrations.
`migrationResolvers`	Community	String array	Custom migration resolvers for resolving migrations to apply.
`skipDefaultResolvers`	Community	Boolean	Skip built-in migration resolvers.
`undoSqlMigrationPrefix`	Teams	String	The file name prefix for undo migrations.
`validateMigrationNaming`	Community	Boolean	Error on migration files whose names do not match the naming conventions.

Migration reading settings

Setting	Tier	Type	Description
`detectEncoding`	Community	Boolean	Whether Flyway should attempt to auto-detect the file encoding of each migration.
`encoding`	Community	String	The encoding of migration scripts.
`placeholderPrefix`	Community	String	The prefix of every placeholder.
`placeholderReplacement`	Community	Boolean	Whether placeholders should be replaced.
`placeholderSeparator`	Community	String	The separator of default placeholders.
`placeholderSuffix`	Community	String	The suffix of every placeholder.
`scriptPlaceholderPrefix`	Community	String	The prefix of every script migration placeholder.
`scriptPlaceholderSuffix`	Community	String	The suffix of every script migration placeholder.

Migration execution settings

Setting	Tier	Type	Description
`batch`	Community	Boolean	Whether to batch SQL statements when executing them.
`callbackLocations`	Community	String array	Locations to scan recursively for callbacks to use to hook into the Flyway lifecycle.
`callbacks`	Community	String array	Callbacks to use to hook into the Flyway lifecycle.
`cherryPick`	Teams	String array	A list of migrations that Flyway should consider when migrating.
`createSchemas`	Community	Boolean	Create the configured schemas if they do not exist.
`dryRunOutput`	Teams	String	File path to output a dry run script to.
`errorOverrides`	Teams	String array	Rules for the built-in error handler.
`executeInTransaction`	Community	Boolean	Whether to execute scripts within a transaction.
`group`	Community	Boolean	Whether to group all pending migrations together in the same transaction when applying them.
`installedBy`	Community	String	The username that will be recorded in the schema history table as having applied a migration.
`lockRetryCount`	Community	Integer	Number of times to try and take a lock at 1s intervals when migrating.
`mixed`	Community	Boolean	Allow mixing transactional and non-transactional statements within the same migration.
`outOfOrder`	Community	Boolean	Allow migrations to be run out of order.
`outputQueryResults`	Community	Boolean	Output a table with the results of queries when executing migrations.
`skipDefaultCallbacks`	Community	Boolean	Skip built-in callbacks.
`skipExecutingMigrations`	Community	Boolean	Skip migration execution.
`stream`	Community	Boolean	Stream migrations when executing them.
`target`	Community	String	The target version up to which to consider migrations.
`validateOnMigrate`	Community	Boolean	Run `validate` command when running `migrate` command.

Flyway schema history settings

Setting	Tier	Type	Description
`defaultSchema`	Community	String	The schema in which to create Flyway's schema history table.
`table`	Community	String	The name of Flyway's schema history table.
`tablespace`	Community	String	The tablespace in which to create Flyway's schema history table.

Schema model settings

Setting	Tier	Type	Description
`schemaModelLocation`	Community*	String	The location of the schema model folder.
`schemaModelSchemas`	Community*	String array	schemas that should be supported by the schema model folder.

Authentication settings

Setting	Tier	Type	Description
`email`	Community	String	Email to be used in conjunction with a personal access token.
`token`	Community	String	Personal access token used for licensing Flyway.

Flyway Pipelines integration settings

Preview

Setting	Tier	Type	Description
`checkDriftOnMigrate`	Community	Boolean	Enables automatic drift checks on migrate.
`pipelineId`	Community	String	An id for identifying your pipeline.
`publishResult`	Community	Boolean	Whether to publish the result of your Flyway run to Flyway Pipelines.

Baseline settings

Setting	Tier	Type	Description
`baselineDescription`	Community	String	The Description to tag an existing schema with when executing `baseline`.
`baselineOnMigrate`	Community	Boolean	Run `baseline` command when running `migrate` command.
`baselineVersion`	Community	String	The version to tag an existing schema with when executing `baseline`.

Clean settings

Setting	Tier	Type	Description
`cleanDisabled`	Community	Boolean	Whether to disable clean.

Validation settings

Setting	Tier	Type	Description
`ignoreMigrationPatterns`	Community	String array	Ignore migrations during `validate` and `repair` according to a given list of patterns.

General namespaces

Namespace	Description
`placeholders`	Placeholders to replace in migrations.

Database-specific namespaces

Namespace	Description
`clickhouse`	Settings specific to Clickhouse.
`db2z`	Settings specific to DB2 zOS.
`oracle`	Settings specific to Oracle.
`postgresql`	Settings specific to PostgreSQL.
`sqlserver`	Settings specific to SQL Server.

Command-specific namespaces

Namespace	Tier	Description
`add`	Community	Settings specific to the `add` command.
`check`	Teams/Enterprise	Settings specific to the `check` command.
`deploy`	Community	Settings specific to the `deploy` command.
`diff`	Teams	Settings specific to the `diff` command.
`diffText`	Teams	Settings specific to the `diffText` command.
`generate`	Enterprise	Settings specific to the `generate` command.
`init`	Community	Settings specific to the `init` command.
`migrate`	Teams	Settings specific to the `migrate` command.
`model`	Teams	Settings specific to the `model` command.
`prepare`	Enterprise	Settings specific to the `prepare` command.
`snapshot`	Enterprise	Settings specific to the `snapshot` command.
`undo`	Enterprise	Settings specific to the `undo` command.

Secrets management namespaces

Usage of per-environment resolvers is preferred.

Namespace	Description
`dapr`	Settings specific to Dapr.
`gcsm`	Settings specific to Google Cloud Secret Manager.
`vault`	Settings specific to Vault.

Deprecated settings

Setting	Tier	Type	Description
`licenseKey`	Teams	String	Your Flyway license key.

* There is no license restriction on this setting strictly speaking, but it is used to configure functionality which is only available at Teams and above.