We currently "support" both Oracle and MySql databases, but in order to do so we have to manually create upgrade scripts in both Oracle and MySql SQL syntax. This is time consuming and prone to errors. In order to automate this process the Rice team is investigating a product called LiquiBase.
LiquiBase seems to be a versatile DB tool that has many features, but right now we are only interested in the versioning and upgrading capabilities.
1. Research the tool
2. Come up with a developers guide for use of the tool in Rice
- We need this tool to create Oracle and MySql upgrade scripts for each release as a minimum.
- Look into where this tool overlaps the impex tool.
In order to research the tool, create a branch of the 220.127.116.11 version of rice. In this new branch of Rice, set up a liquiBase directory inside the scripts/upgrades/1.0.1 to 18.104.22.168 directory.
Translate the current db-upgrade scripts (located in the db-updates directory) into the format recommended for LiquiBase.
Please write the developers guide here: