Upgrade scripts

Previous Next

An upgrade script is an SQL script that is intended be run on a target machine in order to upgrade your USoft application to a new release.

Upgrade scripts produced by USoft Delivery Manager are presented in a specific format that makes it easy for administrators or DBAs on a target machine to know what to do. This picture shows a typical set of upgrade scripts as may be found in the "scripts" section of a release folder:

DL_clip0017

These scripts, all associated with application "MYAPP", must be executed in the order indicated by the sequence numbers.

The name fragment following the sequence number is either "pre", "upg" or "post". This shows the script's processing order:

Files with sequence numbers in the range 100 - 199 have "pre". The sequence numbers and the letters "pre" show that these files are pre-upgrade scripts: they are to be run BEFORE the database upgrade script (if any).

There is at most 1 file in the range 200 - 299, always with sequence number 200, that has "upg" and is known as the database upgrade script.

Files with sequence numbers in the range 300 - 399 have "post". The sequence numbers and the letters "post" show that these files are post-upgrade scripts: they are to be run AFTER the database upgrade script (if any).

The last name fragment before the ".sql" file extension is either "rdbms", "ure.active", or "ure.disabled". This indicates the script's processing mode: an indication that the script must be run against the Rules Engine normally, or against the Rules Engine with all rules disabled, or directly against the RDBMS.

 

See Also

Upgrade

Pre-upgrade scripts

Database upgrade script

Post-upgrade scripts

Writing an upgrade script