LiquiBase

LiquiBase 1.4.0 has been released. Major features include:

• IntelliJ Plug-in Support
• Added support for specifying schemas in change log
• MaxDB/SAPDB Support
• Refactored Code
• Can specify data types as java.sql.Types.*
• Support for composite foreign keys
• Improved Maven support
• 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.4″;
xsi=”http://www.w3.org/2001/XMLSchema-instance”;
schemalocation=”http://www.liquibase.org/xml/ns/dbchangelog/1.4
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.4.xsd”;>

Download LiquiBase 1.4 from:

http://www.liquibase.org/download.html

For you IntelliJ IDEA users out there, there is now a LiquiBase plugin available through the Intellij plug-in manager.

Like the Eclipse plug-in, the IntelliJ plugin allows you to refactor your database like you refactor code using a “Refactor” context menu on database objects. These changes are automatically saved to a change log file.

A “LiquiBase” context menu on the database explorer allows you to migrate your database, roll back changes, generate documentation, and more.

Additional refactoring and better documentation will be added in upcoming releases.

As usual, please let us know if you have any questions or suggestions.

The newest version of LiquiBase now has a Grails plug-in available. To install the plug-in, simply run “grails install-plugin liquibase”.

Full documentation on the Grails plug-in is available at http://www.liquibase.org/manual/latest/grails.html

LiquiBase 1.3 has been released. Major features include:

• Added <custom> change
• Added <executeCommand> change
• Added <createProcedure> change
• Added sqlCheck precondition
• Added dbdoc documentation generator
• Added Spring migrator
• Added tablespace support to createTable, createIndex, addPrimaryKey, and addUniqueConstraint
• Added defaultCascade attribute to addForeignKeyConstraint
• Can have multiple comma-separated contexts per change set
• Database Diff checks column types and nullability
• DiffChangeLog will write to a file specified with the –changeLog flag
• Database Diff checks views
• Added ability to control strippig of comments and splitting of lines in tag
• Added Postgres support to auto-increment related refactorings

Many bugs have been fixed as well, including:

• Restored Java 6 Support
• Absolute path changelogs are handled correctly on Windows
• 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.3″;
xsi=”http://www.w3.org/2001/XMLSchema-instance”;
schemalocation=”http://www.liquibase.org/xml/ns/dbchangelog/1.3
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.3.xsd”;>

Download LiquiBase 1.3 from:

http://www.liquibase.org/download.html

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

LiquiBase 1.1.1 has been released to address issues found with the diff tool in the 1.1 version.

LiquiBase 1.1 has been released. Major new features include:

• Support for additional databases: DB2, Derby, Sybase (not fully tested), and HSQL
• Support for “unsupported” databases
• Database Diff Tool
• Database Creation Script Generator
• new DBMS attribute on change set tag that allows you to specify what databases to run the change set against
• “verify” command that checks for change log problems without attempting to execute any
• “status” command that shows information on unrun change sets
• Handle date/time and numeric values better on inserts and setting default values
• 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.1"    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog/1.1    http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-1.1.xsd">

Download LiquiBase 1.1