RTS Project

There is a new folder in the RTSDB project called DBUpgradeUtilityScripts. This folder will have files named 1.sql, 2.sql, 3.sql etc. The DBUpgradeUtility is something Matthew wrote that reads and executes these files one at a time. This utility checks a table called DBSettings to see what the ver (version) is. If the ver is 2 then it will only run scripts 3.sql, 4.sql, etc.

There is also a file called AlwaysRun.sql that is always run regardless of the version number and is run after the number scripts are run. Currently this file has the RTS security settings that the JADIP security uses.

The DBUpgradeUtility will have to be modified slightly to be generic enough to work for RTS but in the mean time we can run these scripts manually.

I've already run these scrips on RTS so this is mostly an FYI.