Configuring Responder/Smart Grid
Upgrade Responder Tables

Version: 10.1

Resource Center Home

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.

Oracle Scripts

SQLServer Scripts

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_XLOCK

9.2 SP3

None

9.2 SP2

RX_REGION_ETR
RX_FEEDER_ETR

9.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_ROLES

9.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_DAY

9.1 SP1

RX_REGIONS
RX_USERS
RX_REGION_ASSIGNMENTS
RX_FEEDERS
RX_ELEMENT_LOCKS

 


Send Comment to documentation@schneider-electric.com