Smart Grid Applications Overview > Responder Overview > Upgrade Existing Responder Implementation > Upgrade Responder Tables |
Version: 10.1 |
To create tables, views, and indices in the Responder database, use the scripts provided with the Responder server installation. By default, the scripts are installed here: Program Files\Miner and Miner\Responder\Developer Resources\. At the time of installation, the user may elect to have them installed elsewhere.
If you have Responder 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.1 SP1 - 9.1.2 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 on your Responder database.
If you are implementing Responder 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
10.1
None
10.0.3
None
10.0.2
RX_LINEDISPLAY_STATUS
10.0.1 SP1
None
10.0.1
No scripts for this release.
9.3.1 SP1
RX_AFFECTED_XFRS
RX_EVENTS_FEEDERLOCK
RX_FAULT_LOCATIONS
RX_SIMULATED_SO_LOADPOINTS
RX_SWITCHING_FOLDERS
RX_SWITCHING_ORDER_FEATURES
RX_SWITCHING_ORDER_REQUESTS
RX_SW_OR_AFFECTED_LOADPOINTS
RX_SW_OR_AFFECTED_XFRS
RX_SW_OR_FEATURES_HISTORY
RX_SW_OR_REQUESTS_HISTORY
9.3.1
No scripts for this release.
9.3 Rev2
RX_RMA_TIMES
9.3 SP1
RX_FAULT_LOCATIONS
9.3
None
9.2.1
RX_REGION_CUSTOMERS
RX_XLOCK9.2 SP3
None
9.2 SP2
RX_REGION_ETR
RX_FEEDER_ETR9.2
RX_HAZARD_ASSIGN_ARCHIVE
RX_HAZARD_ASSIGN_HISTORY
RX_HAZARD_ASSIGNMENTS
RX_HAZARDS_ARCHIVE
RX_HAZARDS_HISTORY
RX_HAZARDS
RX_INC_DEV_ASSIGN_ARCHIVE
RX_INC_DEV_ASSIGN_HISTORY
RX_INC_DEV_ASSIGNMENTS
RX_INC_FEAT_ASSIGN_ARCHIVE
RX_INC_FEAT_ASSIGN_HISTORY
RX_INC_FEAT_ASSIGNMENTS
RX_PERMISSION
RX_PROBABLE_STATE_CANDIDATE
RX_REGION_MODE_ASSIGNMENTS
RX_ROLE_TASKS
RX_ROLE
RX_TASK_PERMISSIONS
RX_TASK
RX_USER_MEMBERSHIP
RX_USER_ROLES9.1.2 SP1
None
9.1.2
RX_INCIDENT_FEATURES
RX_INCIDENTS_ARCHIVE
RX_INCIDENT_DEVICES_ARCHIVE
RX_INCIDENT_FEATURES_ARCHIVE
RX_LOADPOINTS_ARCHIVE
RX_CUSTOMERS_ARCHIVE
RX_CUST_LOADPOINTS_ARCHIVE
RX_CREW_ASSIGNMENTS_ARCHIVE
RX_CREWS_ARCHIVE
RX_CREW_MEMBERS_ARCHIVE
RX_TRUCKS_ARCHIVE
RX_TAGS_AND_GROUNDS_ARCHIVE
RX_FEEDER_CUSTOMERS
RX_T_MAJOR_EVENT_DAY9.1 SP1
RX_REGIONS
RX_USERS
RX_REGION_ASSIGNMENTS
RX_FEEDERS
RX_ELEMENT_LOCKS