Database Refactoring With 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.
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
A good article is available here.
Related Posts
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically to your feed reader.
Comments
No comments yet.
Leave a comment