9.3 SP1 Upgrade Scripts

The following implementation scripts must be run on your Responder SQLServer database to add the correct tables, views, and indices to upgrade Responder to version 9.3 SP1. When upgrading Responder execute ONLY the Upgrade script(s) that fall between your previous release and the new release to which you are upgrading. Do NOT execute any Implementation Scripts.

With the release of 9.3 SP1, the Implementation scripts have been modified to change a few fields. These modifications are not in the upgrade scripts and should be made manually. Those marked with an asterisk (*) are required. All others listed below are optional. These changes must be made consistently across all Responder tables in all databases.

* Change the length of the Region, RegionID, and Owner fields to 38.
Change the length of the Mobile_Phone and Home_Phone fields to 15 (RX_CREW_MEMBERS, RX_CREW_MEMBER_ARCHIVE, RX_CREW_MEMBERS_HISTORY tables).
International Utilities Only: Change fields with a type of varchar2 to nvarchar2.

Responder requires two databases: Responder and Archive. Some scripts are run on the Responder database and some on the Archive database. In the list below, the database on which the script should be executed is in parentheses.

930sp1_01_RxTables_mssql.sql (Responder)

930sp1_02_ArchiveTables_mssql.sql (Archive)

Open the SQL Server Query Analyzer window, connecting to the Responder database as the schema owner (e.g., RESPONDER).
Execute the 930sp1_01_RxTables_mssql.sql script. This script creates the database tables required by Responder.
Open the SQL Server Query Analyzer window, connecting to the Archive database as the schema owner (e.g., ARCHIVE).
Execute the 930sp1_02_ArchiveTables_mssql.sql script. This script creates the database tables required by Responder Archive Explorer.