Update Database Schema

<< Click to Display Table of Contents >>

EQuIS 7  >>  SPM > SPM Desktop > Configuration >

Update Database Schema

This article describes how to update the schema of an existing EQuIS database to include the tables required by the SPM. The SPM Schema addition includes RT_SPM_*, DT_SPM_*, and AT_SPM_* tables as well as required records in ST_GROUP_TYPE.GROUP_TYPE and RT_LOOKUP.LOOKUP_TYPE.

 

Copy SPM Schema File to EQuIS\db Folder

 

Copy the SPM Schema file included with the SPM install from the SPM DB folder:

 C:\Program Files\EarthSoft\SPM\db\schema.SPM.xme

 

to the EQuIS db folder:

 C:\Program Files\EarthSoft\EQuIS\db

 

20000-CopyToDatabaseFolder

Log In to an EQuIS Database from EQuIS Professional

 

Launch EQuIS Professional and log in to a facility in the target database. The login steps are detailed in the Log into an EQuIS Database article.

 

Note: The EQuIS Login window is the same for EQuIS Professional and the SPM.

 

Update the Database with the SPM Schema

Follow the steps in Update EQuIS Database article to apply the SPM schema.

 

Right-click anywhere in the Update Database(s) form and hover the mouse over Module(s). This will display all of the schema update files that are present in the database directory.

 

The Update function will only process those schema files with check marks in the corresponding check box; uncheck any schemas that are not desired in the current update process. Confirm that the SPM is present and checked.

 

20000-UpdateDatabaseModules

 

Expand the node next to the database record to review the changes that will be made by adding the SPM Schema.

 

20000-UpdateDatabaseChanges

 

Click the Update button.

 

Note: To use SPM with more than one database, each database must be updated to the SPM Schema. More than one database can be selected for a batch update.

 

Update Status Displayed

 

A message will appear confirming the update success. Contact EarthSoft support, support@earthsoft.com if the update fails.