--- layout: blog subtitle: "Flyway 4.2.0 Released" permalink: /blog/flyway-4.2.0.html ---

Hot on the heels of Flyway 4.1.0 and the two patch releases that followed it, here is Flyway 4.2.0!

## Highlights

These are the highlights of this release:

- Pivotal Greenplum support
- Support for multiple migrations within a single transaction
- Overall polish

Let's dive right in!

### Greenplum support

With Greenplum Flyway has now added support for its 20th relational databases!

### Support for multiple migrations within a single transaction

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 set to `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.

### Overall polish

The improvements outlined above are by far not the only ones part of this release. Here are a few more:

- Much improved clean for Oracle
- PostgreSQL DROP INDEX CONCURRENTLY support
- Better support for classpath scanning with newer Tomcat versions
- And much more!

## Grab it while it's hot!

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.

Flyway is brought to you with by Axel Fontaine, Boxfuse and the many contributors.

P.S.: Spread the word, follow @flywaydb on Twitter and subscribe to our monthly newsletter below to be notified about updates.