.svg)
.svg){kind=icon}
.svg){kind=icon}
Find the solution that's right for you
Contact us for a limited-time, special offer when you choose or switch to Liquibase.
Liquibase vs. Flyway
How does Flyway (Redgate) stack up against Liquibase? Find out which database DevOps tool is right for you.
Database change
management tools
Liquibase and Flyway are both open-source database migration tools popular for versioning, deploying, and tracking database changes. Both offer:
Premium & Open Source
Foundational open-source (free) and advanced premium (paid) versions
Extending CI/CD
Capabilities to extend CI/CD to the database change workflow
Migration
A migrations-based approach to database changes
Liquibase helps you bring DevOps to the Database
Supports the broadest set of databases with advanced features
Work from where you want and meet up with your colleagues somewhere new each quarter.
More Flexibility
More flexibility in your database changes with artifact-based deployments
More Control
More control over execution updates and batch releases
Simple
Enables you to standardize best practices and simplify repeatable actions
DevOps Metrics
Improves database observability with DevOps metrics for your pipeline
Comparing Liquibase & Flyway
Flyway | Liquibase | |
|---|---|---|
FEATURES | ||
Supported databases | 51 Relational Databases and Data Warehouses | 60 Relational Databases, Data Warehouses, and NoSQL Databases |
Change definitions and ordering changes | Numbered SQL Files | Rearrangeable ChangeLogs (SQL, XML, JSON, or YAML) |
Changes are not applied to environments where the changes are already present | ||
Programmatically skip or batch changes by creating subsets of changes to apply | ||
Control the execution of an update based on the state of the database | ||
Dry runs | $ | |
Create multi-step Workflows to standardize best practices, simplify actions, and improve governance and control | ||
Allow Rollbacks to undo a database change | $ | |
Target, or cherry pick, a change or set of changes to roll back | $ | $ |
Validates database code against predefined rules set by DBAs on-demand or in automation | $ | $ |
Compare the state of two databases to detect drift or malicious code | $ | $ |
Java-based migrations | ||
Migrations with Spring Boot | ||
Measures and provides database DevOps metrics for your pipeline |
Scale and expand with the broadest database support
Liquibase’s proactive approach and massive community support means more databases—and more diverse databases, including NoSQL—to cover your needs today and tomorrow.
Download
.svg){kind=icon}
.svg){kind=icon}
Update, manage,
and deploy changes with ease
Flyway offers linear versioning using filenames for change deployments, which causes tedium as things need to change. Liquibase uses artifact-based deployments with ChangeLogs, which are collaborative, rearrangeable sets of changes.
.svg){kind=icon}
Control the execution of updates and batch releases
Liquibase makes it easy to skip or batch changes by creating subsets of change with Labels and Contexts. With Preconditions, you can control the execution of an update based on the state of the database.
.svg){kind=icon}
Improve governance by standardizing best practices
Customize and automate multi-step workflows to enable simple, repeatable actions.
.svg){kind=icon}
Database observability to monitor DevOps metrics
Liquibase’s unique Structured Logs make it easy to bring database change and deployment metadata to your DevOps dashboards to enable continuous improvement for your databases.
See why the database DevOps community trusts Liquibase
“Liquibase is much more powerful compared to Flyway since it is much more flexible in nature.”
Kunnath Rahul
Software Engineer
Enterprise Software Company
“Comparing Liquibase and Flyway, I found Liquibase to be easier to learn and faster to implement than Flyway. Liquibase is also more flexible than Flyway.”
Ming Li
CEO
Computer Software Company
I love the flexibility with the schema changes. I don't have to restrict my team to "only XML" way. It is possible to come up with schema changes in YAML and JSON, which is the order of game nowadays.
Liquibase has helped us with implementing reliable version control and a CI/CD pipeline for our data warehousing needs. The space for database version control leaves a lot to be desired, but thankfully Liquibase has that covered! We have paired Liquibase with GitHub and GitHub actions to reliably ensure all of our environments are in sync and easily track our deployments.
As database administrator and consultant, Liquibase is a great tool. It frees up DBA time to manually sync database schema between DEV, TEST and PROD environments. By doing schema comparison programally, it gives me the peace of mind that all database objects are identical between different environments. We could also delegate the task to operation team.
"An ease of error-prone and quick database deployments both on-prem and on cloud integrated with CI/CD DevOps Automation."
Liquibase brought our database changes and data correction processes up to speed with our code deploys which were already automated. It allows us to rely on automated validation as well as fit into our current software development lifecycle processes and CM software using a central versioned artifact capable of being deployed through our current CD pipeline.
We use the Liquibase tool for DB deployment automations using the CICD process. It helped us a lot by reducing human error with the standard audit reporting structure integrated with it.
"Use Cases and Deployment Scope We use Liquibase to handle version control and source code control of SQL scripts and database changes and for the deployment and (if needed) rollback of the same. It's helped us go from arbitrary SQL changes that we tried to manually track, to having a reliable, repeatable, accurate account of what's in our database structure."
Liquibase addresses challenges related to database schema management, version control, collaboration, and deployment automation. Its scope of use cases spans software development, CI/CD, microservices, data migration, compliance. As applications evolve, the database schema might require refactoring. Liquibase supports the controlled refactoring of database structures while preserving data integrity.
"We use Liquibase to maintain our changelogs while transforming our data in snowflake and deploying it to test and prod. Liquibase changelogs help us keep up to date with our changes and do the rollback in case of any error. Liquibase also provides many validation features that will come in handy if you want to establish checks during your code deployment. It's a great product with excellent customer service."
Change log management organize and database changes in a systematic manner. Changes are organized into a series of change sets, each representing a specific change or a set of related changes.
