Working with the Command Line Interface or Batch Files (Silent Mode) - Intergraph Smart Instrumentation - Installation & Upgrade - Intergraph

Intergraph Smart Instrumentation Installation and Upgrade Guide

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Installation & Upgrade
Smart Instrumentation Version
2018 (12.0)

You can carry out certain upgrade operations from the Command Line Interface (Silent Mode) or by batch (.bat) file, in the same way you can install Smart Instrumentation.

The CLI involves running a script with arguments specifying the operation to be actioned. A batch file uses the same scripts but written in a text file, such as notepad, and saved as a .bat file. Double clicking the batch file runs the script.

SHARED Tip You can schedule the batch file to run at a convenient time using Windows scheduler (for example, during the night or over the weekend).

The silent flag in the CLI or batch file allows you to upgrade Admin and Domain schema's, without any messages being displayed or actions needed.

The following scripts are used for silent mode operation in the CLI or in a .bat file to perform Administration Module operations:

  • When you see <> in any of the scripts, you must replace the contents of the<> with the required value and delete the <>. For example, Upgrade <Domain Name>, becomes Upgrade HexagonPPM.

  • Silent is an optional flag that runs the command in the background where no messages or dialog boxes are displayed.

  • If there is a connection failure, the procedure is stopped and a message is displayed in the Log file.

The Upgrade CLI also runs the Rebuild Stored Procedures and Triggers procedure. If you are requested by Customer Support to rebuild stored procedures and triggers without upgrading your database, you can do this using the CLI in silent mode. For more information, see Working with the Command Line Interface.

Upgrading the Admin Schema

You can upgrade the Admin Schema using the schema name or schema ID. Type the following in the CLI/batch file:

For Schema Name

Upgrade adminschema

silent

sa <Database System Administrator password>

For Schema ID

Upgrade 9999

silent

sa <Database System Administrator password>

Examples:

Using schema name

  • Upgrade adminschema

    silent

    sa mypassword1

Using schema ID

  • Upgrade 9999

    silent

    sa mypassword1

Upgrading a Domain Schema

After upgrading Smart Instrumentation, you must first upgrade the Admin schema before upgrading your domain schema's.

You can only upgrade one Domain schema at a time. To upgrade all domains in one go (batch), see below Upgrading all Schemas.

You can use the <Domain Name> or <Project ID> of one or more Domain schema's, type the following in the CLI/batch file:

Upgrade <Project (domain) ID>

silent

or

Upgrade <Domain name>

silent

Examples:

  • Upgrade 12345

    silent

or

  • Upgrade MyDomain

    silent

Upgrading all Schema's

This option allows you to upgrade all your schema's, Admin and Domain.

Upgrade all

silent

sa <Database System Administrator password>

SHARED Tip For a complete list of domain project IDs, run the following SQL Query: SELECT * FROM Project.