LiquiBase

A quick demo of the LiquiBase Database Refactoring IDE is now available on the LiquiBase site.

It shows how to connect to your database, apply several refactorings to your database, then update an independent database with the new changes–all from the comfort of an IDE environment.

The IDE is available as either a stand-alone tool or as an Eclipse plug-in.

View the demo

More Information

Version 0.6 of the LiquiBase IDE and the Eclipse Plug-in have been released. This version does not add new functionality, but does fix a showstopper bug that prevented the creation of change log files.

Information on downloading the new version is available on the download page.

LiquiBase 1.2.1 is a minor bugfix release to address the following issues:

• Ordering of default values and not null clauses on some databases including Oracle
• Sequences were not included in the generateChangeLog output

The update is available on the download page

LiquiBase 1.2 has been released. Major features include:

• Support for H2 database
• Support for InterSystems Cache` database
• Support for <sqlfile> change
• Improved error messages
• <sql> tag can contain a <comment> tag
• Change log file references can be absolute
• SQL in <sql> tag can be ; or ‘go’ delimited
• New clearCheckSums command in command line migrator
• Support for version 0.5 of the LiquiBase IDE and Eclipse Plugin

Many bugs have been fixed as well, including:

• Sybase support fixes
• Handle –defaultsFile correctly
• Handle command line parameters correctly on Windows systems
• Other bug fixes

Upgrading is simply a matter of replacing the liquibase.jar file. To take advantage of newer change log features, change your XSD declaration to:

<databasechangelog xmlns="http://www.liquibase.org/xml/ns/dbchangelog/1.2"     xsi=”http://www.w3.org/2001/XMLSchema-instance”     schemalocation=”http://www.liquibase.org/xml/ns/dbchangelog/1.2     http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.2.xsd”>

Download LiquiBase 1.2

I have released the initial version of a LiquiBase IDE. The idea behind it is to do for database refactoring what refactoring tools like IntelliJ and Eclipse have done for code refactoring.

The initial release is intended primarily to look for feedback from users and from people with experience writing Eclipse plug-ins and RCP applications.

Current functionality includes:

• Applying refactorings to a database and having them stored in a change log file
• Executing a change log file against a database
• Tagging a database

While the functionality may be a bit rough around the edges (not a lot of validation, will probably get an error message or two) it is functionally complete for creating and applying changes.

Plans for the final 1.0 release include interfaces for rollbacks and rollback-management, database diffs, and more.

If you would like to help out with the development of the IDE/plug-in or would like to create a similar plug-in for your favorite IDE, please let me know. It is a very large undertaking and I could use some help