A set of SQL scripts is provided to upgrade earlier tranSMARt database to release 16.3
The scripts are available in transmart-data in directory updatedb/release-16.2 to upgrade from 16.2 to 16.3 and in directory updatedb/release-16.1 to upgrade from 16.1 (or the 1.2.x releases) to release 16.2
Most local installations have their own changes to consider. Usually these are simple updates, such as making columns wider to cope with longer local text values.
In such cases it shoudl be possible to use these scripts to update an existing database without the need to reload data.
More complicated changes
An approach that has been used successfully in a number of instances is to compare a local instance to a clean install of the latest transmart database, or to the a clean install of the previous release to find a list of all local changes.
Comparison scripts are available from email@example.com
There are two possible comparison. To compare all tables, sequences and views to report on changes or to dump all definitions and to compare everything.
The changes can be applied to the local instance to bring it up to the latest relase, and the comparison scripts repeated to ensure only local customizations remain.