LiquiBase is an open source (LGPL), DBMS-independent library for tracking, managing and applying database changes. LiquiBase software 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.
Here are some key features of “LiquiBase”:
· 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
Requirements:
· Java Runtime Environment (JRE) – tested with JRE6 on Ubuntu 7.10
What’s New in This Release:
· IntelliJ plug-in support.
· Support for specifying schemas in the change log.
· MaxDB/SAPDB support. Refactored code.
· The ability to specify data types as java.sql.Types.
· Support for composite foreign keys.
· Improved Maven support.
· Bugfixes.