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.
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 (from Smart Instrumentation 13.1 HF10 or higher) 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> (from Smart Instrumentation 13.1 HF10 or higher) 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>
For a complete list of domain project IDs, run the following SQL Query: SELECT * FROM Project.