Flyway Pros and Cons

Setting up a new database for a new environment is made easy. The write once, migrate anywhere methodology of flyway reduces lot of burden on the developers Review collected by and hosted on G2.com.

It uses single migration config table per database which makes it difficult to use multiple heterogeneous applications use the same database. Review collected by and hosted on G2.com.

Smooth integration with build tools like maven and detailed documentation Review collected by and hosted on G2.com.

Rollback of executed migrations are little tricky to do, and also, migrations are very strict meaning change in migration cause migrations to fail. Review collected by and hosted on G2.com.

I appreciate that it works with diverse SQL backends. We use their Docker container to reliably manage both local and production environments. Review collected by and hosted on G2.com.

Migrating large codebases to flyway can be tedious to get into the appropriate file structures. Review collected by and hosted on G2.com.

We can configure it very easily irrespective of any technology. Review collected by and hosted on G2.com.

Rollback functionality is still not consistent Review collected by and hosted on G2.com.

You can put SQL scripts directly into a folder to run migration scripts as opposed to using a library to send queries to a server. Review collected by and hosted on G2.com.

It is limited in its fearures if we want to have a intricate rollback system Review collected by and hosted on G2.com.

Out of the box integration with Spring. Easy to start. Review collected by and hosted on G2.com.

There is no migration rollback option. Need to change the migration hash manually in database. Review collected by and hosted on G2.com.

The script fails with checksum if we try to manually update something Review collected by and hosted on G2.com.

I think there is nothing which I dislike about flyway Review collected by and hosted on G2.com.

easy scripting, easy monitoring with concept of db migration Review collected by and hosted on G2.com.

didn't dislike anything from flyway, it jst worked fr me on fly Review collected by and hosted on G2.com.

The ease of integration with Jenkins and usage. Review collected by and hosted on G2.com.

Nothing really. All that matters to me is performance and FlyWay is right on target. Review collected by and hosted on G2.com.

managing DB migrations for me

easy to copy DB from one env to another Review collected by and hosted on G2.com.

if by mistake someone missed up with one old migration, everything will fail Review collected by and hosted on G2.com.