Install SQL scripts for a Smart Materials database - Intergraph Smart Construction - 8 - Reference - Hexagon PPM

Intergraph Smart Construction Retired Feature Reference

Language
English
Product
Intergraph Smart Construction
Search by Category
Reference
Smart Construction Version
8

Complete the following steps in each Smart Materials database that you plan to interface with Smart Construction.

  1. Log on to SQLPlus using the user name and password of your Smart Materials database.

  2. Using SQL Plus, browse to the Materials folder in the Smart Construction server installation location. For example, navigate to [Drive]:\Program Files\SmartConstruction\SPCServer\Support\Materials.

  3. Run file scripts located in the Materials folder.

    If you do not see a folder for your version of Smart Materials, run the scripts that are located in the folder named for the most recent previous version relative to your version. For example, for version 8.1, run the scripts in the 7.1.1.SP01 folder.

    • If you have installed Smart Materials system, run the following scripts:

      • m_api_site_spc_spec.sql

      • m_api_site_spc_body.sql

      • m_api_site_spc_Type.sql for version 7.1.1.SP01 or later

For more information, see Configuring a Smart Materials system using Site API.