Flyway
Flyway

101
81
15
Liquibase
Liquibase

90
83
32
Add tool

Liquibase vs Flyway: What are the differences?

Liquibase and Flyway are both Java-based database tools for refactoring and versioning; Flyway uses SQL to define database changes, while Liquibase can also use XML, YAML, or JSON.

What is Flyway?

Flyway lets you regain control of your database migrations with pleasure and plain sql. Solves only one problem and solves it well. Flyway migrates your database, so you don't have to worry about it anymore.

What is Liquibase?

Developers store database changes in text-based files on their local development machines and apply them to their local databases. Changelog files can be be arbitrarily nested for better management.

Want advice about which of these to choose?Ask the StackShare community!

Why do developers choose Flyway?
Why do developers choose Liquibase?
What are the cons of using Flyway?
What are the cons of using Liquibase?

Why do developers choose Liquibase vs Flyway?

  • Flyway is typically used by developers who want complete control over their SQL; it’s designed to do that one thing, and to do it well.
  • On the other hand Liquibase is often cited as being a great database tool that supports many databases.
What companies use Flyway?
What companies use Liquibase?

Sign up to get full access to all the companiesMake informed product decisions

What tools integrate with Flyway?
What tools integrate with Liquibase?
    No integrations found

    Sign up to get full access to all the tool integrationsMake informed product decisions

    What are some alternatives to Flyway and Liquibase?
    Sequel Pro
    Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.
    PostGIS
    PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.
    Open PostgreSQL Monitoring
    Open PostgreSQL Monitoring is a free software designed to help you manage your PostgreSQL servers.
    DataGrip
    A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.
    Knex.js
    Knex.js is a "batteries included" SQL query builder for Postgres, MySQL, MariaDB, SQLite3, and Oracle designed to be flexible, portable, and fun to use. It features both traditional node style callbacks as well as a promise interface for cleaner async flow control, a stream interface, full featured query and schema builders, transaction support (with savepoints), connection pooling and standardized responses between different query clients and dialects.
    See all alternatives
    Decisions about Flyway and Liquibase
    Miguel Suarez
    Miguel Suarez
    Lead Developer · | 7 upvotes · 30.8K views
    atJobsrepublicJobsrepublic
    PostgreSQL
    Liquibase
    Flyway
    #Backwards-compatible
    #Migration

    Flyway vs Liquibase #Migration #Backwards-compatible

    We were looking for a tool to help us integrating the migration scripts as part of our Deployment. At first sight both tools look very alike, are well integrated with Spring, have a fairly frequent development activity and short release cycles.

    Liquibase puts a lot of emphasis on independence with the DB, allowing you to create the scripts on formats like JSON and YML, abstracting away from SQL, which it's also supported. Since we only work with one DB type across services we wouldn't take much advantage of this feature.

    Flyway on the other hand has the advantage on being actively working on the integration with PostgreSQL 11, for it's upcoming version 6. Provides a more extensive set of properties that allow us to define what's allowed on what's not on each different environment.

    Instead of looking for a tool that will allow us to rollback our DB changes automatically, we decided to implement backwards-compatible DB changes, for example adding a new column instead of renaming an existing one, postponing the deletion of the deprecated column until the release has been successfully installed.

    See more
    Interest over time
    Reviews of Flyway and Liquibase
    Review ofFlywayFlyway

    it works with complex SQL script and it is very high customizable.

    How developers use Flyway and Liquibase
    No items found
    How much does Flyway cost?
    How much does Liquibase cost?
    Pricing unavailable
    News about Flyway
    More news
    News about Liquibase
    More news