org.flywaydb:flyway-reports

See release notes here

Bug fixes

• Fixed a bug where Redshift CREATE, ALTER and DROP IDENTITY PROVIDER statements were run inside a migration transaction, which Redshift does not support

Java compatibility

• ConfigurationExtension.copy() no longer requires jackson-databind on the classpath; if it's absent, copy() falls back to a shallow copy

Internal dependency

• Upgraded RgCompare to 1.62.6.5172

See release notes here

Breaking changes

• JSON results with timestamps now include a UTC offset. Reports generated will not be compatible with previous versions of Flyway. API users relying on getTimestamp or setTimestamp will need to use OffsetDateTime instead

Changes

• Flyway now warns when validate resolves no migrations from the configured locations but the schema history contains applied migrations

• mcp server project load will no longer raise an error if a .conf project was detected in a default location outside of the project root

• OSS no longer recognises the 'publishResult' or 'checkDriftOnMigrate' parameters which had no effect

Bug fixes

• Configuration details defined against a specific environment, such as a custom schema history table or default schema, were lost when Flyway switched to that environment

• The Docker provisioner could not connect to Oracle 23 and later containers, failing with ORA-12514, because it requested the wrong pluggable database service

Java compatibility

• CockroachDB is now provided as a standalone database module. API users targeting CockroachDB should include the new CockroachDB module instead of relying on the PostgreSQL module

Library upgrades

• Upgraded adoptium/temurin25-binaries from 25.0.3+9 to 25.0.4+7

• Updated BouncyCastle to 1.85 to address a High severity Uncontrolled Recursion advisory

• Updated Oracle SQLcl in the Flyway Docker oracle image to 26.2.0.181.2110, resolving CVE-2026-68494 in jackson-core

See release notes here

New features

• deploy command result now includes execution time in milliseconds

• environments_<name><setting> and flyway<setting> environment variables can now use any letter casing in their prefix, e.g. ENVIRONMENTS_PRODUCTION_PASSWORD

Database compatibility

• Databricks Lakebase is now recognised as a supported PostgreSQL-derivative database type in public preview

• snapshot history is now supported on Databricks

Bug fixes

• Databricks identifiers containing a backtick produced invalid SQL

• Databricks migrations could fail at the unlock step with a Delta ConcurrentAppendException; the lock keepalive no longer races the unlock

• Issue 4259 Fixed afterConnect callback not being fired on the migration connection

• Fixed an issue that prevented several after*OperationFinish SQL callback scripts (clean, validate, undo, repair, baseline) from ever running

• Fixed an issue where the Docker provisioner for Oracle would immediately exit

• Fixed dry run failing on Databricks with "Unable to switch connection to read-only" error

Java compatibility

• Issue 4240 Log execution of Java callbacks, matching SQL/script callback logging

Library upgrades

• Upgraded jansi to use org.jline.jansi package

See release notes here

New features

• Add support for new 'IncludeOnlineIndexCreation' option for Oracle

• check drift and check changes JSON output now includes an id for each difference, allowing drift to be resolved against specific objects

• Flyway MCP server now available, exposing development-time tools an AI agent can call. These tools run flyway commands for both state based and migrations projects

Changes

• Include the offending SQL in error messages for Flyway Desktop when debug logging is disabled

• the docker provisioner now reports a dedicated error code when a SQL Server or Oracle container is provisioned without accepting the database vendor's EULA

Bug fixes

• Fixed the 'auth' command incorrectly showing a "no locations configured" warning that only applies to migration commands

Library upgrades

• Updated jackson-databind to 3.1.5 / 2.22.1 to address a High-severity Incorrect Authorization advisory

See release notes here

New features

• Add support for new 'disable-constraints-for-static-data' option for PostgreSQL

Changes

• -h help for migrate, info, validate, clean, and undo now lists relevant configuration parameters and a usage example instead of just a description

• Oracle SQL error output no longer shows the redundant SQL State and Error Code lines, as the ORA-#### code is already in the message

• testConnection now keeps the configured environments available so provisioners that reference another environment (for example the docker provisioner's sourceEnvironment) resolve correctly when testing an inline environment

• testConnection now reports provisioning progress (e.g. Docker container start-up) when progress output is enabled

• the docker provisioner now reports clear, dedicated errors when the Docker CLI is not installed or the Docker daemon is not running

• the legacy compose-file configuration of the preview docker provisioner is deprecated and now logs a warning; use the docker-compose provisioner instead

• using 'auth' without the '-IAgreeToTheEula' flag defaults to an interactive EULA agreement process

Bug fixes

• Fixed an issue where authentication warnings could be displayed multiple times during a Flyway run

• Issue 4253 Fixed FlywayUnknownMigrationTypeException when schema history table contains legacy SPRING_JDBC type from older Flyway versions

Performance improvements

• Improved Flyway CLI cold start time by switching driver JARs from eager static classpath loading to lazy dynamic loading

Library upgrades

• Upgrade Snowflake from 4.0.2 to 4.3.1

See release notes here

New features

• smart docker provisioner keepAlive reuses the build database container across Flyway commands

Changes

• filesystem location 'not found' messages now report the effective working directory and prompt you to check it, since running Flyway from the wrong working directory (without -workingDirectory) is a common cause

• Native Connectors mode is now enabled by default for Cassandra

• outOfOrder mode is now reported at info level instead of as a warning

• The preview docker environment provisioner has been renamed to docker-compose. Existing docker provisioner configurations that use a compose file continue to work via automatic forwarding.

Bug fixes

• A missing callback location (including the default filesystem:callbacks) is now skipped instead of being logged as an error or failing the command

• drift resolution script generation failures no longer fail the check drift command; drift is still reported and any scripts that can be generated are still written

• Fixed drift resolution failing to generate scripts when the drift included object types whose names contain spaces (e.g. user-defined types)

• The smart docker provisioner now starts Postgres and MySQL build containers with valid credentials and a usable default schema, so provisioning and migrating against them succeeds

Performance improvements

• skip building an unused Flyway instance for configuration-only commands (e.g. constructMigrationName, parseMigrationName, comparison-capabilities), reducing their startup latency

Library upgrades

• Upgraded com.fasterxml.jackson.core:jackson-databind from 2.21.2 to 2.22.0

• Upgraded tools.jackson.core:jackson-databind from 3.1.1 to 3.1.4

See release notes here

New features

• Added a check.driftResolutionFolder setting to configure the folder in which drift resolution scripts are generated when drift is detected

• Flyway CLI now exits with a distinct exit code derived from the error code when a FlywayException is thrown

Changes

• check drift, changes and dryrun commands now report phase-level progress when outputProgress is enabled

See release notes here

Bug fixes

• Fix FLYWAY_TOKEN and FLYWAY_EMAIL environment variables not being recognised for PAT authentication

See release notes here

Changes

• Flyway now warns when an offline permit is due to expire within the next 30 days

• Improved progress reporting for PostgreSQL, MySQL and SQLite

Bug fixes

• Oracle EXEC statements preceded by a comment now parse correctly

Java compatibility

• API users now must include a flyway Licensing module dependency to be recognized as Redgate edition

See release notes here

New features

• Flyway can load custom SQLFluff rules for use in the Check command

Java compatibility

• API users are now required to include the flyway-proprietary module to use Redgate proprietary features

Internal dependency

• Upgraded RgCompare to 1.58.2.4353

New features

• Environment Variable resolver syntax now works in all flyway configuration parameters, not just environment connection properties

Database compatibility

• Issue 4238 Cockroach v26 is now supported

Bug fixes

• fix crash in check code when SQLFluff emits LXR violations for files containing a UTF-8 BOM

• Fixed misleading "try running the 'auth' command" warning appearing when already running auth command

Library upgrades

• Upgraded ch.qos.logback:logback-classic from 1.2.3 to 1.2.13

• Upgraded org.apache.derby:derby from 10.16.1.1 to 10.17.1.0

• Upgraded org.apache.logging.log4j:log4j-core from 2.17.1 to 2.25.4

Internal dependency

• Upgraded RgCompare to 1.58.1.4262

Bug fixes

• flyway repair against a dry-run target no longer fails for SQL baseline migrations

• license text files now included in Flyway distributions

New features

• Flyway now supports Native Connectors mode for the Deploy command

Changes

• Auth command now defers to existing license providers instead of redundantly re-authenticating. License output now reports the acquisition method.

• configuration errors caused solely by obsolete parameters now throw ObsoleteConfigurationParametersException, exposing the obsolete parameters as structured data

• Issue 4229 Gradle plugin is now compatible with Gradle's configuration cache for environment variable and system property inputs

• obsolete parameter exception payload now includes a reason field explaining why each parameter is obsolete

• simplified namespace short-circuiting (aka scoped namespacing) so that mixing scoped and unscoped namespaces is allowed

Database compatibility

• Issue 4232 Add support for DROP ... IF EXISTS and CREATE ... IF NOT EXISTS for Oracle parser

Bug fixes

• Issue 4230 Only create synonyms for Oracle SHTs when the name includes lower case characters

Library upgrades

• Upgraded adoptium/temurin25-binaries from 25.0.2+10 to 25.0.3+9

• Upgraded com.google.jimfs:jimfs from 1.3.0 to 1.3.1

• Upgraded org.apache.maven.plugins:maven-antrun-plugin from 1.7 to 1.8

• Upgraded org.apache.maven.plugins:maven-compiler-plugin from 2.3.2 to 3.15.0

• Upgraded org.apache.maven.plugins:maven-deploy-plugin from 3.0.0-M1 to 3.1.4

• Upgraded org.apache.maven.plugins:maven-failsafe-plugin from 3.1.0 to 3.5.5

• Upgraded org.apache.maven.plugins:maven-install-plugin from 3.0.0-M1 to 3.1.4

• Upgraded org.apache.maven.plugins:maven-jar-plugin from 3.0.2 to 3.5.0

• Upgraded org.apache.maven.plugins:maven-resources-plugin from 2.5 to 3.5.0

• Upgraded org.apache.maven.plugins:maven-surefire-plugin from 3.1.0 to 3.5.5

• Upgraded org.apache.maven.wagon:wagon-http from 2.12 to 3.5.3

• Upgraded org.codehaus.mojo:versions-maven-plugin from 2.7 to 2.21.0

• Upgraded org.junit.jupiter:junit-jupiter from 6.0.1 to 6.0.3

• Upgraded org.junit.platform:junit-platform-launcher from 6.0.1 to 6.0.3

• Upgraded org.mockito:mockito-core from 5.18.0 to 5.23.0

• Upgraded org.mockito:mockito-junit-jupiter from 5.18.0 to 5.23.0

• Bumped aws-secretsmanager-jdbc from 2.0.4 to 2.1.0

Internal dependency

• Upgraded RgCompare.Cli from 1.55.1.3732 to 1.56.1.3818

New features

• Flyway now supports Azure Key Vault as a secrets resolver

• Flyway now supports Native Connectors mode for Cassandra. The JDBC-based approach has been deprecated

Changes

• flyway prepare with -prepare.source=schemaModel now fails with a clear error when the configured schema model directory does not exist

• "initSql" has been deprecated. Please use the "afterConnect" callback instead

• The Flyway Secret Manager feature is no longer available under Teams license

Bug fixes

• Fix pluginConfigurations in the Maven and Gradle plugins not being handled by Flyway

• Retry Informix table drops on ISAM file lock errors

Internal dependency

• Upgraded RgCompare.Cli from 1.52.6.3589 to 1.55.1.3732

New features

• Added a new rule: RG23 - Configurable forbidden alias names

• Add a "checksumIncludeReferencedScripts" parameter under "Oracle" namespace to control whether referenced scripts are included in checksum calculation

Bug fixes

• Fix NullPointerException when comparison engine returns null collection fields

• in json output of check code, "file_pos", "file_pos_end" properties will now adjust for windows line endings present in scripts. Suggested fix content will now attempt to match the line endings used by the script.

• Fix a bug where the "validate" operation may cause a "NullPointerException"

• Issue 4221 Fixed Snowflake connectivity failure after JDBC driver update when PUBLIC schema does not exist

• fix CLI scoped namespace resolution when nested parameters are not immediately after their flag

• Fixed incorrect file position returned in code review json for some types of sql fluff insertion fixes

Java compatibility

• Issue 4223 Support the Gradle configuration cache in flyway-gradle-plugin

Internal dependency

• Upgraded RgCompare.Cli from 1.52.3.3436 to 1.52.6.3589

New features

• Added a new rule: RG22 - Ensure the same table is not created and then dropped or vice versa in the same script

• Flyway includes SQLite support in Native Connectors mode

Changes

• Added additional properties to json output of check code: "engine", "file_pos", "file_pos_end" and (optional) "fixes".

• Release note generation now reads from the database, enabling sub-product notes to be included

Bug fixes

• Fix RG18 and RG19 handling of bracketed identifiers

Internal dependency

• Upgraded RgCompare.Cli from 1.52.1.3430 to 1.52.3.3436

New features

• Added a new rule: RG19 - Simple check to ensure table names are not pluralized. More complex pluralizations should be handled by hand.

• Added a new rule: RG20 - Object names should be contained within square brackets.

• check -code now generates a SARIF 2.1.0 report file (.sarif) alongside JSON and HTML reports, enabling integration with GitHub Code Scanning, Azure DevOps, and other SARIF-compatible tools

• added check.code.noqaSeverity setting for configuring the severity of the warning about use of --noqa in migrations checked by SQLFluff as part of check -code

• Added a new rule: RG21 - This is a configurable rule that can enforce naming prefixes for multiple object types. (Table, View, Procedure, Function, Schema)

Changes

• Code Analysis renamed to Code Review in output from check command

• the regex rule engine used by check -code will no longer automatically convert line endings before applying rules for the contents of migrations

Bug fixes

• Flyway now correctly exits with a non-zero exit code when migrations fail and multiple report generators are loaded

• Fix parsing of backticks for quoted strings in MySQL

Library upgrades

• Updated Snowflake JDBC driver to 4.0.2

• Upgrade aws-secretsmanager to 2.0.4

Internal dependency

• Upgraded RgCompare.Cli from 1.52.0.3327 to 1.52.1.3430

Changes

• Implement non statement level callbacks in Native Connectors for undo, info, baseline and repair

Bug fixes

• serverId in Maven plugin now correctly respects user-configured value via flyway.serverId

• fixed NPE in Oracle database type when using instrumentation agents like JaCoCo

• fix NullPointerException in SnapshotVersionRetriever when applied migrations include null-version entries (repeatable migrations, SCHEMA markers)

• snapshot no longer saved during dry run for migrate, undo, and deploy commands

• Gradle plugin now correctly reads connectRetries, connectRetriesInterval, and failOnMissingLocations from the flyway extension configuration

• Java Migrations correctly show the script path when an exception is thrown due to duplicated versions

Performance improvements

• improved startup time for lightweight CLI commands like flyway version and flyway auth

Library upgrades

• Upgrade lombok to 1.18.44

New features

• Flyway now supports using the 'init' command to automatically update TOML configuration files for Desktop users

Changes

• InsertRowLock now supports custom locking strategies for databases without primary key support

• Removed SQL Server 'IgnoreSynonymDependencies' comparison option

• changed the snapshot history limit default to 5, so that ad-hoc rollbacks are available for recent deployments by default

Database compatibility

• Foundational support for Babelfish added.

Bug fixes

• Fix NullPointerException when executing callbacks where callback name is null

• drift resolution folder path in JSON output now serializes as an absolute file path string instead of a URI

Library upgrades

• Upgrade Jetty-server from 12.0.21 to 12.1.6

• Upgrade Jackson from 3.0.4 to 3.1.0

Bug fixes

• report filenames and drift resolution folder now included in JSON output when check -drift fails with failOnDrift enabled

• Fixed an issue where Flyway failed when applied migrations specified in 'cherryPick' were not found in Native Connectors mode

• Oracle Schema History Table synonyms no longer appear as drift in Check reports

Library upgrades

• Upgrade Jackson from 2.19.1 to 3.0.4

New features

• Add flag -check.generateReport to control whether check should write the result to a file

Changes

• flyway check now honors environment-specific cleanDisabled override when no provisioner set for the build database

• running snapshot against an Oracle database without specifying schemas will now use the default schema if set

Bug fixes

• Auth can now be output as JSON when outputType=json is set

New features

• check -changes now honors target parameter for setting a target version

Changes

• Added alias for azureAdInteractive resolver to entraId

• Redgate Clone documentation marked as deprecated and Flyway Desktop sections removed

Database compatibility

• Oracle now uses synonyms on new schema and snapshot history tables to enable them to be called unquoted

Bug fixes

• Fixed issue where configuration parameters would not be listed when running --help on check with a flag specified

• Fixed issue where drift resolution filter generation would fail when drift found involving objects with no schema

• Fix static data ordering when on Windows and using a string primary key

Library upgrades

• Bump Oauth2-oidc-sdk to 11.32

Breaking changes

• The 'passOnRegexMatch' field in the Code Analysis Regex Rule is no longer supported

• The 'plugin' namespace for configuration parameters is no longer supported

• The environment variable 'REDGATE_LICENSING_PERMIT_PATH' has been replaced by the standard 'FLYWAY_OFFLINE_PERMIT_PATH'

• Flyway no longer ships the default Redgate regex ruleset

• Reports now display results from separate flyway command invocations on the main page. Reports no longer contain a timestamp dropdown.

• The 'majorRules', 'minorRules', 'majorTolerance', and 'minorTolerance' settings have been removed and are now no longer supported in Code Analysis

• MongoDB support via JDBC has been removed. MongoDB is now supported only in Native Connectors mode

• Support for SQLFluff versions prior to '1.3' has been removed You can find out more at Flyway V12 - updating from V11

Database compatibility

• Issue 4194 Add support for nested IF statements in Snowflake parser

Java compatibility

• Changed the method signature of the public 'CommandExtension' interface

• CompositeResult is now a record

Library upgrades

• Upgraded RgCompare.Cli from 1.48.1.2582 to 1.50.1.2648

Thanks to 023-dev for reporting these issues.

Library upgrades

• Upgraded RgCompare.Cli from 1.48.1.2503 to 1.48.1.2582

• Upgraded sqlfluff from 3.5.0 to 4.0.0

• Issue 4152 Upgrade google-cloud-spanner to 2.34.1 and google-cloud-storage to 2.60.0 to fix CVE-2025-55163

Thanks to lesniakd for reporting these issues.

Library upgrades

• Upgraded RgCompare.Cli from 1.47.1.2438 to 1.48.1.2503

New features

• generated drift incorporate script will now contain object existence checks for SQL Server

Performance improvements

• When check is called with both -drift and -changes flags, -drift is now always run first as there will be a performance improvement when using a build environment

Library upgrades

• Upgraded RgCompare.Cli from 1.47.0.2331 to 1.47.1.2438

• Upgrade Netty from 4.2.7 to 4.2.9

Changes

• model, generate, and prepare commands now return full selection output instead of a list of names of included dependencies

Library upgrades

• Upgraded RgCompare.Cli from 1.46.0.2246 to 1.47.0.2331

• Upgrade MariaDB from 2.7.11 to 2.7.13

New features

• It is now possible to switch off automatic dependency handling for Oracle when performing comparison operations. This is done by setting includeDependencies = false in the [redgateCompare.oracle.options.behavior] section of the config file.

Changes

• LICENSES-THIRD-PARTY.txt format has changed. Will now refer to the shipped license file instead of duplicating the license text.

Database compatibility

• Verified compatibility for SingleStore 8.9

Bug fixes

• Fixed an issue where Flyway treated skipped SQLFluff code analysis as a successful linting run

Library upgrades

• Upgraded RgCompare.Cli from 1.45.1.2176 to 1.46.0.2246

Bug fixes

• Fixed issue when running check -drift against a database with no snapshot history table

Java compatibility

• CLI now ships with Java 25

Library upgrades

• Upgraded RgCompare.Cli from 1.45.1.2083 to 1.45.1.2176

• Upgraded MongoDB Sync Driver to 5.6.1

New features

• 'testConnection' command is now supported in Native Connectors mode

Changes

• When using Oracle in 'Native Connectors' mode, Flyway now fails early during database initialization if the migration execution tool cannot connect

• When using MongoDB in 'Native Connectors' mode, Flyway now fails early during database initialization if the migration execution tool cannot connect

Bug fixes

• Fix issue with obtaining the value of SQLPlus placeholders on Oracle 26ai

• fixed an issue with using the create-database provisioner where a reprovision operation would not fully occur if no additional provisioner configuration was specified

Library upgrades

• Upgraded RgCompare.Cli from 1.45.1.2021 to 1.45.1.2083

• Upgraded sqlfluff from 3.4.2 to 3.5.0

Bug fixes

• Fixed an issue where the bundled SqlFluff was not included with some versions of the CLI

Known Issues

• Redgate bundled SQLFluff was not shipped in this release due to a packaging problem

New features

• Added ability to run code analysis on individiual scripts with 'check.scriptFilename' and new 'SCRIPT' scope

• Snapshot history version column will now be populated when a database is used as the source for the snapshot

• Comparison options can now be configured via the command-line

• testConnection command can test Comparison Engine connections

• snapshots can be written to an s3 bucket and read from an s3 bucket when performing drift checks

• Flyway now supports reporting the usage of '--noqa' tags that suppress code analysis linting

Bug fixes

• Fixed missing descriptions for SQLFluff rules RG07, RG08, RG11, and RG12

• Issue 4172 Fix getting Oracle metadata properties

• Issue 4169 Fixes an additional connection being created when running migrate or undo

Library upgrades

• Upgraded RgCompare.Cli from 1.45.1.1851 to 1.45.1.2021

Thanks to toadzky and MahogaWeerasinghe for reporting these issues.

New features

• It is now possible to capture and store snapshots in a target database in a flyway snapshot history table following a migrate, undo, or deploy action. These snapshots can be used for drift analysis and potentially for rollback. For more information see snapshots .

• standard logging is now included with outputType=json; it is posted via STDERR

Changes

• if deployed snapshot is configured but not found, drift detection will warn rather than fail, allowing for initial deployment to succeed

Bug fixes

• Fixed issue where namespace short-circuiting would not work when environment parameters were set

• Test connection will only output success if it is successful

Library upgrades

• Upgraded RgCompare.Cli from 1.45.1.1821 to 1.45.1.1851

Known Issues

• Redgate bundled SQLFluff was not shipped in this release due to a packaging problem

New features

• Regex code analysis now reports all identified violations instead of only the first one

• Added a new 'testConnection' command to test the validity of a configured database connection

Changes

• Flyway now uses the packaged SQLFluff for Enterprise users by default, unless this feature is explicitly turned off

Database compatibility

• Updated latest version of SQL Server to 2025

• Oracle now respects the encoding configuration parameter when reading SQL migrations.

Bug fixes

• Resolve issue causing output progress only being set when the user is set.

Library upgrades

• Upgraded RgCompare.Cli from 1.44.0.1673 to 1.45.1.1821

• Upgrade mssql-jdbc to 12.10.2

• Upgrade Couchbase SDK to 3.9.2

• Upgrade Databricks JDBC to 3.0.1

• Upgraded Netty to 4.2.7

New features

• Flyway now provides clearer error messages when online authentication methods fail

Changes

• Simplified setting debugMode and quietMode in Loggers. When using Flyway via the Java API, Log level is now configured via LogFactory.setLogLevel(LogLevel). All appropriate loggers will now honor the LogLevel including quietMode (most loggers were previously flawed and would ignore this)

Library upgrades

• Upgraded RgCompare.Cli from 1.44.0.1656 to 1.44.0.1673

New features

• Flyway now supports configuring Offline Permits via command-line parameters and TOML configuration

Changes

• Released first set of Redgate code analysis rules for SQLFLuff (RG01-RG08)

Database compatibility

• Issue 4129 Update Snowflake driver to 3.27.0

Bug fixes

• Issue 4135 Improved redaction of passwords in JDBC connection strings

• Issue 4151 No longer crash when calling ClassUtils.getInstallDir if jars located at root of filesystem

Library upgrades

• Upgraded RgCompare.Cli from 1.44.0.1580 to 1.44.0.1656

Thanks to mendhak, crammond, calou and mmitch for reporting these issues.

New features

• Packaged SQL Fluff added to docker images

• Enhanced exception handling during Code Analysis to allow Flyway to continue generating the Report if partial results are already available

• Flyway now provides more comprehensive details in code analysis results

Bug fixes

• Issue 4155 Schema history index is now created in a specified tablespace for Oracle and DB2

• stop detecting schema model folder as a SQL server schema model when it was empty but had empty sub folders

Java compatibility

• S3ClientFactory has moved to the flyway-locations-s3 module

Library upgrades

• Upgraded RgCompare.Cli from 1.44.0.1569 to 1.44.0.1580

Thanks to acarstensen for reporting these issues.

Changes

• JVM Startup time added to verbose logs

• Issue 4119 Update shaded aws-secretsmanager-jdbc to not include io.netty to remove vulnerable dependencies

Library upgrades

• Upgraded RgCompare.Cli from 1.43.0.1498 to 1.44.0.1569

Thanks to numeraltwo for reporting these issues.

Java compatibility

• Deprecated constructor on Location class. Use new static factory method instread.

• it is now possible to implement locations via plugins

Library upgrades

• Upgraded RgCompare.Cli from 1.42.2.1345 to 1.43.0.1498

Changes

• Flyway now provides clearer error messages when attempting to load an unlicensed plugin

Due to issues in the release process, this version has been skipped

New features

• It is now possible to define beforeDeploy, afterDeploy, and afterDeployError callbacks in locations specified by the callbackLocations parameter. This allows logic to be executed before and after script execution for state-based deployments.

• deploy command now supports errorOverrides, allowing for graceful handling of SQL Server PRINT statements

• it is now possible to specify callback-specific locations using the callbackLocations parameter

Database compatibility

• Couchbase foundational support is now in preview

Bug fixes

• Exceptions using batch will now display the line number of the offending SQL causing the error

Java compatibility

• The Callback interface now extends a generic interface. The compile-time signature is unchanged.

Library upgrades

• Upgraded RgCompare.Cli from 1.41.0.1246 to 1.42.2.1345

• Bump netty-common-http to 4.1.125 to fix CVE-2025-58057

New features

• A new 'failOnError' mode has been introduced in Flyway 'check' code analysis

• add support to generate undo script for state based model migration

Changes

• 'majorRules' and 'minorRules' parameters in Code Analysis are now deprecated

Bug fixes

• Fixed an issue where fetching the list of static data tables may fail when using Azure AD interactive authentication

Library upgrades

• Upgraded RgCompare.Cli from 1.40.0.1194 to 1.41.0.1246

New features

• afterConnect callback is now available outside of Native Connectors

Database compatibility

• Fixed jar for aws-secretsmanager

Library upgrades

• Upgraded RgCompare.Cli from 1.39.4.1185 to 1.40.1.1194

• Bump Netty-common, netty-resolver and netty-codec-http2 to 4.1.124 to fix CVE-2025-55163

New features

• Table of useful configuration options will now print if no migrations found

Changes

• When performing operations using the results of database comparison capabilities (model, generate, prepare, diffText) for SQL Server and Oracle databases, selecting static data differences will fail if the associated table does not exist in the target database and is not also included for selection

Library upgrades

• Upgraded RgCompare.Cli from 1.39.0.1098 to 1.39.4.1185

Breaking changes

• Removed flywayTelemetryManager from CommandExtension API signature

Database compatibility

• Update community dbs to 10.24.0

Bug fixes

• MongoDB Native Connectors now handles the case where no authentication is explicitly specified gracefully

Library upgrades

• Upgraded RgCompare.Cli from 1.38.0.1077 to 1.39.0.1098

New features

• New configuration option that allows a WHERE clause to be specified for comparison operations on each static data table to filter the returned rows

Changes

• Added full aws-secretsmanager-jdbc dependencies

Library upgrades

• Upgraded RgCompare.Cli from 1.38.0.1042 to 1.38.0.1077

New features

• Oracle Database Flashback support for Native Connectors Oracle

Changes

• 'passOnRegexMatch' parameter in Regex Code Analysis is now deprecated

Database compatibility

• Added community db IRIS

• Added community db QuestDB

Library upgrades

• Upgraded RgCompare.Cli from 1.38.0.974 to 1.38.0.1042

• Upgraded sqlfluff from 3.4.1 to 3.4.2

Changes

• Code analysis reports now display both the number of files with violations and the total number of violations

• Issue 4089 Gradle plugin now uses Extensions API over deprecated Conventions API

Library upgrades

• Upgraded RgCompare.Cli from 1.37.0.926 to 1.38.0.974

• org.apache.commons:commons-lang3 to 3.18.0

• Upgraded Jackson from 2.15.2 to 2.19.1

Thanks to mokamoto12 for reporting these issues.

New features

• A new parameter has been added to Regex Rule configuration files, allowing individual Regex Rules to be selectively disabled

Database compatibility

• Fabric Data Warehouse is now available in Preview

Bug fixes

• Fixed an issue where baseline scripts were not included during check -changes and check -drift

Library upgrades

• Upgraded RgCompare.Cli from 1.36.0.820 to 1.37.0.926

• mssql-jdbc 12.6.3 -> 12.10.1

New features

• The 'help' command now provides targeted help for individual 'check' sub-commands

Changes

• Update terminology in docs from AAD to Microsoft Entra

• New SQL Server projects will now surface 'PRINT' statements as info logs instead of warnings with a default error override in the project settings

Bug fixes

• Fixed an issue where the 'shouldExecute' configuration was ignored by Flyway during Callbacks execution in Native Connectors mode

Breaking changes

• error output is now a record and supports custom payloads for different exception types

New features

• Backup provisioner will no longer attempt to create users that already exist

• It is now possible to set generate.usePlaceholders=true to allow the generate verb to place placeholders into generated files

• Flyway now supports specifying the code analysis scope for migrations

• Flyway now supports configuring the SQL dialect for code analysis via a dedicated configuration parameter

Changes

• Native Connectors is now available via the API

• Issue 4092 Gradle tasks now use lazy instantiation

• flyway prepare target parameter will now default to the value of the environment parameter if the source is schema model or migrations. This makes it more straightforward if the connection details are provided as parameters rather than as a toml environment, and makes the command neater if prepare and deploy are chained together.

Bug fixes

• Deleted migrations and baseline markers are now ignored when running check -drift and check -changes

Library upgrades

• Upgraded OJDBC 11 from 21.1.0.0 to 21.18.0.0

Thanks to mokamoto12 for reporting these issues.

New features

• The snapshot command now creates any missing parent directories for the provided snapshot file path

• MongoDB Native Connectors now supports outputQueryResults for Javascript migrations

• Flyway code analysis now reports analyzed files more accurately

Changes

• Deprecated MongoDB using legacy JDBC driver. Please make sure Mongosh is installed to use Native Connectors

• improved error message information for script migration errors

Database compatibility

• Fabric SQL Database support added for foundational capabilities

Bug fixes

• Fixed an issue where Flyway would throw an error during code analysis if no specific connection URL was provided

Library upgrades

• Upgraded RgCompare.Cli from 1.33.6.583 to 1.34.8.647

Bug fixes

• SQLFluff Code Analysis will now show the line number and position of a violation

• suppressed incorrect warning about transactions appearing when running prepare

Library upgrades

• Upgraded RgCompare.Cli from 1.33.6.573 to 1.33.6.583

Breaking changes

• OSS command-line artifacts will now be downloaded from the release tag on GitHub instead of Maven

New features

• Flyway now allows enabling or disabling Code Analysis Rules Engines via configuration

• diffText console output will use the unified diff format when -color=never is set or color support has not been detected.

Changes

• difference IDs are now included in diffText console output.

Bug fixes

• Fixed an issue where the MongoDB connection string's 'defaultauthdb' configuration was not being correctly applied

Library upgrades

• Upgraded RgCompare.Cli from 1.33.3.433 to 1.33.6.573

• Databricks JDBC driver 2.7.1 -> 2.7.3

Bug fixes

• Jackson-databind is now a dependency of flyway-core

• Fixed a bug where SQLFluff code analysis reported files with violations even when the violation count was zero

• Issue 4074 MongoDB Native Connectors now throws when there is a writeError

Database compatibility

• NC Mongo now uses temporary files to remove issues with " characters in migrations

• Support Create table inside IF THEN block for BigQuery

New features

• Reports will now display the environments used by Flyway

Library upgrades

• Upgraded RgCompare.Cli from 1.30.3.102 to 1.32.0.254

Thanks to marcust for reporting these issues.

Bug fixes

• Issue 4068 Snowflake will not set a role after a migration if the current role is the same as the original role before a migration

Changes

• Issue 4046 Make jackson libraries optional on flyway-core. JSON and TOML features will require these libraries

• added Oracle debug information to documentation

• Flyway now throws error if PAT is set in OSS edition

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26414 to 1.30.3.102

Thanks to trainman and axelfontaine for reporting these issues.

Bug fixes

• Fixed an issue where the TLS auto-configuration failed to recognize a supported object type in the client PEM file

• flyway will raise an error if a provisioner is requested to be used when dry run is set

• The PostgreSQL parser now supports CASE statements within a BEGIN ATOMIC statement

Changes

• Deprecate detectUserByUrl and detectPasswordByUrl methods from the DatabaseType API

Database compatibility

• Issue 4055 Add support for STREAMLIT objects to Snowflake parser

New features

• Native Connectors now supports the afterConnect callback. This will function similarly to initSql which this will be replacing

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26351 to 1.30.2.26414

• Upgraded sqlfluff from 3.3.1 to 3.4.0

Thanks to andreir229 for reporting these issues.

Bug fixes

• MongoDB Native Connectors can now use the database from the url instead of the default test database

New features

• Issue 4033: Add support for the AWS Wrapper with PostgreSQL

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26299 to 1.30.2.26351

• Update databricks-jdbc to 2.7.1

• Update jetty-server to 9.4.57.v20241219 to fix CVE-2024-6763

Thanks to heikkis, swarna7602, lambdaupb, and oimo23 for reporting these issues.

Changes

• Native Connectors for Oracle now supports clean

• Added new error code FAILED_BASELINE_MIGRATION to convey failure when migration a baseline

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26158 to 1.30.2.26299

• Upgraded azure-identity 1.14.2 -> 1.15.4

• Upgraded msal4j 1.15.1 -> 1.20.0

New features

• Flyway now supports Native Connectors mode for Oracle Database

Bug fixes

• Fixed an issue where diff comparisons of empty schema models to empty would use the SqlServer comparison engine

• Fixed an issue where the MongoDB connection string's 'authSource' parameter was not being correctly applied

• Fixed an issue where performing a dry run on non-Native Connectors databases triggered a misleading Native Connector warning message

Library upgrades

• Upgraded RgCompare.Cli from 1.30.2.26104 to 1.30.2.26158