The system installs the HxGN EAM database by completing the following process. You can also upgrade and configure the database manually.
Only Microsoft SQL Server database administrators or equivalent should perform any function described in this section.
Before upgrading an existing database, we strongly recommend backing up the existing database and keeping a copy of the back-up in a safe place.
The system updates the log directory you created in the previous section, and then creates all of the scripts to the directory. Using Microsoft SQLCMD, the system executes the scripts created by the Installation Wizard, using the Microsoft SQLCMD utility.
If you are upgrading and configuring the database manually, we recommend that you use the following syntax when executing the Microsoft SQLCMD utility:
sqlcmd |
-S ‘servername’ |
d ‘databasename’ |
|
-U ‘userid’ |
|
-p ‘password’ |
|
i ‘file name with path’ |
|
o ‘log file name with path’ |
If you clicked Yes, the system automatically runs the following scripts. If you clicked No, you must run the scripts manually, one at a time, in the given order listed below, as the system administrator user you created previously.
Script |
Function |
---|---|
stxcreate.sql |
Creates the text system tables, which are used by 28sl120u.sql and 30sd120u.sql |
stxdata.sql |
Populates the text system tables with seed data from the test systems by using insert scripts Before running 28sl120u.sql, run 7idef.squl to set up the session variables. To ensure that 7idef.sql and 28sl120u.sql are run during the same session. We recommend that you combine these two scripts into one script and run it using SQLCMD or run the scripts individually from Management Studio. |
10st120u.sql |
Creates or alters the HxGN EAM table structure in the database using 7idef.sql |
stobjmasterdata.sql |
Creates master data to check table, view, and database objects. |
28sl120u.sql |
Populates the system basic data using existing data from R5INSTALL using 7idef.sql |
30sd120u.sql |
Contains a statement to populate several tables with seed data using 7idef.sql |
50sc120u.sql |
Creates table constraints, indexes, and sequences |
60spr120.sql |
Creates database procedures, functions, and views |
70stg120.sql |
Creates all database triggers |
80ed120u.sql |
Seed data manipulation |
dbinstall.sql |
Sets up privileges to run HxGN EAM Extended functions |
-
To uninstall the Microsoft SQL Server database, back up the entire database, and then drop it. We strongly recommend that you back up the database before you drop it.
-
See the Microsoft SQL Server documentation for more information on how to back up the database.
-
As a part of regular database maintenance, you must periodically remove redundant rows from sequence tables. To clean the database, open the Management Studio and execute: execute p_cleanout_id_tables