Skip to content
A change management system for databases based on Liquibase
Branch: master
Clone or download
Pull request Compare This branch is 17 commits ahead, 317 commits behind liquibase:master.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.circleci Revert "Reverting renaming changes from dbmanul" May 8, 2018
liquibase-cdi
liquibase-core
liquibase-debian
liquibase-integration-tests
liquibase-maven-plugin
liquibase-rpm
.gitattributes
.gitignore
LICENSE.txt
README.md
RELEASE_NOTES_0.1.md
RELEASING.txt
bug_mapping_with_upstream.txt
changelog.txt
dbmanul-debian
dbmanul-rpm
findbugs-exclude.xml
findbugs.core.fbp
liquibase.fbp
pom.xml
pr_mapping_with_upstream.txt

README.md

DB-Manul

A change management system for databases based on Liquibase

This fork of the Liquibase source aims to:

  • Improve the integration tests
  • Improve code documentation and maintainability
  • Support more Oracle Database features
  • Support different connections for changesets (e.g. use an administrative connection for creating tablespaces and a "regular" connection for normal schema updates)
  • Modernise the code to use JDK 8 features.
  • Internationalise the messages

For a current list of changes, fixes and improvements, please see: https://github.com/dbmanul/dbmanul/blob/master/RELEASE_NOTES_0.1.md

Current status summary

Last updated: December 30th, 2017

PLEASE NOTE THAT THE FORK, IN GENERAL, SHOULD BE CONSIDERED UNSTABLE FOR THE MOMENT. A lot of work is currently being done to get all integration tests (OSS + commercial RDBMSs) green; manual testing of features like CDI, RPM/Debian packaging, Spring integration etc. comes after that.

Database support:

Full support (DBMS-specific integration tests green, Software should be usable for everyday tasks):

  • Apache Derby (tested: 10.13.1.1)
  • H2 database (tested: 1.4.195)
  • HyperSQL (hsqldb) (tested: 2.4.0)
  • IBM DB2 LUW Express (tested: 10.6)
  • MariaDB (tested: 10.2.6, with InnoDB)
  • MySQL (tested: 5.7.18, with InnoDB)
  • Oracle Database (tested: 12.1.0.2 and 12.2.0.1)
  • PostgreSQL (tested: 9.6)
  • Microsoft SQL Server (MSSQL) (tested: 2016, 2017, Express & Developer Editions)

Somewhat working (work in progress):

  • Firebird (a problem in snapshotting causes duplicate indexes to be generated to FOREIGN KEY constraints). Regular change sets (forward migration) seems to work fine. as deferrable, which is a functionality not present in MySQL/MariaDB AFAIK).
  • SAP SQL Anywhere 17 (formerly known as Sybase AS Anywhere)
    • Basic functionality is working
    • Currently failing tests:
      • runUpdateOnOldChangelogTableFormat (should not affect new users)
      • Change logs working on more than one schema simultaneously
  • SQLite: Generally working except for operations that would be possible with ALTER TABLE on other RDBMS (see https://dbmanul.atlassian.net/browse/DBM-3 for details)

Unstable multiple integration tests to fail

  • IBM Informix (work started, but several SQL generators are broken; needs considerable work to get it back again) Currently completely broken due to a regression involving catalog and schema names

Untested / Work has not started yet:

  • SAP Adaptive Server Enterprise (ASE) (formely known as Sybase Adaptive Server)
  • Microsoft SQL Server (in case-sensitive mode)
  • Microsoft SQL Server (via JTDS driver)
  • Determine the oldest supported versions of the RDBMSs, procure them, and test compatibility

Functionally beyond regular changesets:

  • Snapshotting can only retrieve attributes that are present in most RDBMS (e.g. names of columns, PKs etc.) Attributes that are specific to a RDBMS (like storage attributes for segments in Oracle) cannot be snapshotted currently.
  • RPM packaging works, there is a small bug if non-release-version directories are used
  • Debian packaging could work (DEBs get generated), but need to set up a Debian box to test it
  • Documentation, website: Not yet updated / reviewed.

Currently untested functionality:

  • CDI
  • Database documentation generation (DbDoc - though automated tests seem to work)
You can’t perform that action at this time.