LiquiBase is an open source (LGPL), DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control.

While there have been many attempts to provide a similar tool, LiquiBase aims to provide a solution that:

Supports merging of changes from multiple developers

• Works well with code branches
• A Database Refactoring IDE-Plugin (short demo)
• Isn't DBMS-specific
• Allows you to manage production data as well as various test datasets
• Works in an environment where multiple machines will be attempting to migrate the database concurrently
• Supports automated change-applying or generation of SQL scripts that can be approved and applied by a DBA
• Supports rolling back changes
• Can create database ”diff“s and can generate change logs from them
• Can auto-generate database change documentation

While we are currently focused on the core Java-based migrator functionality, additional features planned include:

• Data extraction for generating test datasets
• Unit testing infrastructure
• .Net support
• And more

Download LiquiBase, read our Quick-Start Guide and join our Mailing List

View a short (6 minute) overview of LiquiBase and more are available in the training section.

We would like to thank Sundog for their generous support of time and resources.