Flyway Pros and Cons

I like that it enables develops, data architects and DBAs to collaborate. It also ensures that only approved changes make it to the database. Review collected by and hosted on G2.com.

While relatively simple to administer, one more tool does cost time. However, the benefit outweighs the cost. Review collected by and hosted on G2.com.

Very rich in functionality. Provide most of the support required for any database application. Version migration for tables and repeatable migration with flyway is hassle free. Flyway also provides support for adding default value to column when we need to add new column with not null constraint. Flyway supports most of the database . I tried flyway with PostgreSQL and SAP hana. Review collected by and hosted on G2.com.

Only one thing, versioned migration and repeatable migration is decided based on naming convantion. Which is difficult for any person who have not used flyway before. Review collected by and hosted on G2.com.

- Ability to define database changes in simple SQL files.

- Lot of ways to do the configuration like maven plugin, properties, config files, or system properties.

- Opinionated naming convention to ensure consistency in large enterprise projects.

- Enable/disable flyway for spring-based applications.

- Reduce startup load by using a flyway strategy to be disabled at startup but can be executed manually later.

- Custom commands to manage database migrations like repair, clean, etc.

- Excellent developer-oriented documentation

- Supports multiple build tools and operating systems. Review collected by and hosted on G2.com.

- High scan times for large number of data changes in case of big projects.

- Execution times could be optimized for large applications. Review collected by and hosted on G2.com.

I used Flyway(Version control) in the last two companies and my projects; it's like magic.

1. easy to integrate.

2. no need to much worried about the DMLs and DDL changes in your database, has to write sql queries and flyway will run them according to the versions.

3.easy to debug. If any query fails can look into the version table and can rerun your scripts.

4. repair method is again a lifesaver(you can enable or disable it). Review collected by and hosted on G2.com.

1. nothing as such I like it and will recommend using this as it's highly reliable and easy to work with the tool. Review collected by and hosted on G2.com.

Automatic database migration through batch scripts placed via spring boot modularised components only via some custom libraries. Review collected by and hosted on G2.com.

Steps corresponding baseline clean install migrate and necessary jars as a mandate. Review collected by and hosted on G2.com.

Profiling! Works like a charm for me

As it helps me to migrate the + setup test env db or dev env db in minutes as in my use case seeded data for app was very different on staging,dev, prod env. Review collected by and hosted on G2.com.

We can have integrated test workflow for entire app deployment life cycle example : migrate test moc db when app is building. Review collected by and hosted on G2.com.

Script checking and migration. Fully automated. Easy to understand and integrate.

Very easy to config, great support on plain sql scripts.Fantastic to install even with complex Databases. Review collected by and hosted on G2.com.

Nothing.In case of changes in script you need to deploy it from scratch but this feature is helpful also. Review collected by and hosted on G2.com.

Flyway handles all the migrations with simple steps and easy configuration plus integration. Review collected by and hosted on G2.com.

I feel like if it could add updating the old migrations if required, with ease.And could provide downfalls if migration seems wrong. Review collected by and hosted on G2.com.

Flyway addresses the pain point of managing the DB Schema version on the head. Not only that but it's CLI APIs help to automate DB deployment along with the Application. Review collected by and hosted on G2.com.

Features I have used I have not quite come across anything which I dislike. Maybe I have to use Flyway more regriously. Review collected by and hosted on G2.com.

the best thing is that it is light and does not require any heavy hardware for installation .Also the configuration is so simole just like plug n play and easy to maintain versions using it. Review collected by and hosted on G2.com.

it does not have any GUI and review apply history is sometimes a little cumbersome. Review collected by and hosted on G2.com.