RSS Feed for This PostCurrent Article

Open Source Database Refactoring Tools


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

  • Data extraction for generating test datasets

  • Unit testing infrastructure

  • .Net support


openDBcopy is a universal database utility to migrate data from and to any database given a JDBC driver.

  • Standard filters are included
  • Custom plugins can be added and/or developed
  • Complete migration project saved as XML for easy re-use
  • Run with GUI or as batch process


dbdeploy is a Java-based database refactoring tool. It has been created by Graham Tackley, Nick Ashley with some help by Sam Newman. It is based on real-world experiences of software development in ThoughtWorks – who also support it’s development.

dbdeploy supports the following DBMS:

  • Oracle
  • MS SQL Server
  • Sybase
  • Hypersonic SQL
  • MySQL

Trackback URL

Sorry, comments for this entry are closed at this time.