topic Database upgrade - SQL generator in Alfresco Archive

Database upgrade - SQL generator

tvanhoec — Fri, 18 Feb 2011 09:20:37 GMT

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. <proper

Re: Database upgrade - SQL generator

frederikherema1 — Fri, 18 Feb 2011 11:14:18 GMT

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.

Re: Database upgrade - SQL generator

tombaeyens — Fri, 18 Feb 2011 13:27:55 GMT

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