dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olatitle@xxxxxxxxx>]

Hi,

OpenMRS uses a tool called Liquibase (http://www.liquibase.org/) to take
care of database changes on application startup.
The tool keeps track of all changes to the database and updates the local
database when starting up the application.
The tools also helps to allow users to create a new database from the
browser when starting up the first time.

All in all it provides some great improvements to usability and simplifies
implementation. I think of the thousand of installations in India needing
database changes as on use case that could benefit from this.....

A summary from OpenMRS on what Liquibase added:
1) All database updates are now executed when the API is started.  No need
to source a .sql file on your database directly.
2) There is a setup wizard in the war file now.  The wizard will walk you
through creating your database and your runtime properties file.

Here's more doc on how OpenMRS uses it:
http://n2.nabble.com/Liquibase-Integration-Branch-Merged-to-Trunk-td2102325.html#a2136404
http://openmrs.org/wiki/Data_Model_Update_Conventions
http://dev.openmrs.org/browser/openmrs/trunk/metadata/model/liquibase-update-to-latest.xml
http://openmrs.org/wiki/Step-by-Step_Installation_for_Developers


Ola Hodne Titlestad |Technical Officer|
Health Metrics Network (HMN) | World Health Organization
Avenue Appia 20 |1211 Geneva 27, Switzerland | Email: titlestado@xxxxxxx|Tel:
+41 788216897
Website: www.healthmetricsnetwork.org

Better Information. Better Decisions. Better Health.