Install SQL scripts for a Smart Materials database - Intergraph Smart Construction - 2017 (5.0) - Administration - Intergraph

Intergraph Smart Construction Administration and Configuration (2017)

PPMProduct
Intergraph Smart Construction
PPMCategory_custom
Administration & Configuration
SPCVersion_custom
2017 (5.0)
SPFVersion_custom
2016 (6.0)
Version_SPMat_custom
8.1

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 (x86)\SmartConstruction\2017\SPCServer\Support\Materials.

  3. Run file scripts located in the Materials folder.

    Select the scripts that correspond to your version of Smart Materials.

    • If you are installing a new 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.0.3 or later

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

      • del_spc_fah_results.sql

      • m_api_site_spc_spec.sql

      • m_api_site_spc_body.sql

      • m_api_site_spc_Type.sql for version 7.0.3 or later

For more information, see Using the Site API Guide delivered with Smart Materials.