Database upgrade - SQL generator

[tvanhoec]

Hey,
We work with Activiti 5.0 (in production) and we want to upgrade to Activiti 5.2 (oracle).

I understand that by changing the databaseSchemaUpdate param the schema should automatically be upgraded. As mentioned in the userguide this is however still experimental and backup is required.
<property name="databaseSchemaUpdate" value="true" />

Therefore my following question (on request off DBA's 😉 😞
Has someone writen a small program (or alike) that generates the SQL-statements to upgrade.

Thx!
Tom

[frederikherema1]

Hi Tom,

The scripts used to upgrade are shipped inside the activiti-engine jar-file. These upgrade-statements are written by hand for every feature added that affects the DB-schema.

These files are located here: /activiti-engine/src/main/resources/org/activiti/db/upgrade

These upgrades are tested on our QA-system on all DB's supported be it with minimal testing, thats why it's still marked experimental.

[tombaeyens]

First of all, it's best to wait for 5.3 which is delivered 1st of March.  As I just fixed a number of problems with the upgrade from 5.0 to 5.1 in oracle.

Best is to run the upgrade in a test environment.  That way you can 1) see the SQL statements in the logs and 2) check if your systems still runs fine on a copy of your production data