Open Source Database Refactoring Tools
By admin on Nov 25, 2008 in open source
LiquiBase
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
-
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
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
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
Sorry, comments for this entry are closed at this time.