2017-04-27 by Axel Fontaine
Hot on the heels of Flyway 4.1.0 and the two patch releases that followed it, here is Flyway 4.2.0!
These are the highlights of this release:
Let's dive right in!
With Greenplum Flyway has now added support for its 20th relational databases!
Flyway always cleanly wraps the execution of a migration within a transaction. This is of course most useful on databases supporting DDL transactions such as PostgreSQL, DB2 or SQL Server as it means and failed statement, whether DDL or DML, will cause the entire migration to be cleanly rolled back.
This in turn means that if multiple pending migrations are migrated in a single run each migration succeeds or fails individually. In certain scenarios, such as new software releases shipping with multiple new database migrations that should really all succeed or fail as one unit, this isn't always the desirable behavior.
To address this we are introducing migration groups. When the new
group property is
true, all pending migrations are executing together in a single database transaction. On databases
with DDL transactions this now means that a single failed statement, will cause all of these migrations to be cleanly
rolled back together.
The improvements outlined above are by far not the only ones part of this release. Here are a few more:
Enjoy Flyway 4.2.0 and grab it while it's hot!
It is the fastest, most complete and most reliable Flyway release so far. All users are encouraged to upgrade.
P.S.: Spread the word, follow @flywaydb on Twitter and subscribe to our monthly newsletter below to be notified about updates.