Upgrade Responder Tables

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.6.1

None

10.2.1d

None

10.2.1c

None

10.2.1b

RX_JUMPER_STEPS

RX_JUMPER_STEPS_HISTORY

RX_JUMPER_STEPS_ARCHIVE

10.2.1a

RX_JUMPERS_ARCHIVE

RX_JUMPERS_HISTORY

10.2.1

No scripts for this release.

10.2

No scripts for this release.

10.1.1

RX_JUMPERS

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

QR code for this page

Was this helpful?