LiquiBase

LiquiBase is an open source, free and cross-platform library software that has been designed from the ground up to be used for managing, tracking and applying database changes, as well as to implement a version control system. It integrates with Apache Ant, Apache Maven, Spring and Servlet.

Features at a glance

Key features include support for merging multiple changes at once from several developers, support for code branches, a database refactoring IDE-plugin, support for Linux, Windows and Macintosh operating systems, support for rolling back changes, Java Integration APIs, and support for automated generation or change-applying of SQL scripts.

Additionally, the software lets user to easily manage production data and several test datasets, create database diffs, generate changelogs from diffs, generate database change documentation, generate and manage rollback logic, as well as to do cluster-safe upgrades.

Among other interesting features, we can mention that LiquiBase supports over 15 database types, as well as the SQL, YAML, JSON and XML file formats, supports extensions and plugins, offers simple commands, such as Drop Column and Create Table, as well as complex ones like Merge Columns and Add Lookup Table.

Under the hood and supported operating systems

The project is written entirely in the Java programming language, which means that it’s cross-platform, supported on all operating systems where the Java Runtime Environment (JRE) is available, including all GNU/Linux distributions, as well as the Microsoft Windows and Mac OS X OSes. It has been successfully tested with both 64-bit and 32-bit hardware platforms.

Availability

For the user’s convenience, this program is distributed as both a pre-built binary package and a universal sources archive. The latest version can be downloaded for free on Softoware, but you can also clone its source code from GitHub. More details can be found on the project’s official web page.

What is new in this release:

• Fixed index column nested tags in generated XML

What is new in version 3.3.3:

• Fixed index column nested tags in generated XML

What is new in version 3.3.2:

• Fixed index column nested tags in generated XML

What is new in version 1.9.0:

• "modifySql" support, "includeAll" support, and Sybase Adaptive SQL Anywhere support.
• Paths in "include" can be relative to the changelog using the "relativeToChangeLog" attribute.
• "stop" has changed.
• A runInTransaction attribute for changeSet.
• Stronger validation in .xsd.
• Better Derby support.
• Some bugfixes.

What is new in version 1.8.0:

• Added SQLite support
• Bug fixes
• Added dropAllForeignKeyConstraints change
• Added onFail and onError precondition failure controls
• Auto-increment specifying on a non-auto-increment table does not fail but simply ignores flag
• Can control onDelete and onUpdate behavior for FK constraints
• Added ability to specify that an index should be unique
• Additional validation step checks for required attributes at run time
• Improved ordering of generated scripts with diff
• Improved command line migrator return codes
• Context checking is case insensitive
• Can specify end delimiter in < sql > change
• Added several new precondition checks
• Custom preconditions can be passed parameters

Requirements:

• Java 2 Standard Edition Runtime Environment