Upgrade Smart Grid Tables

To create the necessary tables for Smart Operations, use the scripts provided with the SOS installation. By default, the scripts are installed here: \Program Files\Miner and Miner\Responder\Developer Resources\Implementation Scripts\Addons. At the time of installation, the user may elect to have them installed elsewhere.

If you have Smart Operations already installed and are upgrading to a later release, you need only run the appropriate Upgrade scripts. The upgrade folders are named with the starting release and the release to which you are going. For example, 9.2.1 - 9.3.0 Upgrade Scripts. If your current release is more than one behind the one to which you are upgrading, you will need to run all of the upgrade scripts between your old release and the new release. This ensures that all of the database enhancements made between the releases are available.

If you are implementing Smart Operations for the first time, you need only run the Implementation Scripts. Do not run any Upgrade scripts for a new implementation.

If the upgrade script adds a new table to your database, your Database Administrator must update the read/write permissions. The table below indicates whether the upgrade tool adds new tables to the database. The table does not list all of the tasks performed, only whether tables are added. "None" does NOT mean the upgrade script does nothing.

Release

Tables Added

9.3.1 SP1

None

9.3 Rev2

SG_RTD_MONITOR

9.3 SP1

SG_TAG_RELATIONSHIP
SG_DYNAMIC_TAG_MAPPER

9.3

SG_RELATIONSHIP
SG_METADATA

Release	Tables Added
9.3.1 SP1	None
9.3 Rev2	SG_RTD_MONITOR
9.3 SP1	SG_TAG_RELATIONSHIP SG_DYNAMIC_TAG_MAPPER
9.3	SG_RELATIONSHIP SG_METADATA