Upgrading the Database - PAS ICS Integrity - 7.3 - Installation & Upgrade - Intergraph

ICS Integrity Installation Guide

Language
English
Product
PAS ICS Integrity
Subproduct
ICS
Search by Category
Installation & Upgrade
PAS Version
7.3

After completing the installation and validating your license, you need to upgrade the database to a newer version. The Database link on the Admin Utility main window opens the Configure Database Connection Parameters window. If your current database version is before Integrity 5.5, you first need to use SQL Server Management Studio to set the compatibility settings to at least SQL Server 2008.

Attention Integrity customers that plan to upgrade to Experion PKS R430. Experion PKS R430 uses Microsoft SQL Server 2012 as its application database. On any Integrity Data Collector importing R430 data, SQL Server 2012 or later is required. If you have any questions or concerns, please contact Technical Support for assistance.

To upgrade an Integrity database:

  1. If your current database version is before Integrity 5.5, use SQL Server Management Studio to set the compatibility level settings to SQL Server 2008 (100) or higher. For more information, see Checking the Compatibility Level in SQL Server.

  2. In the Admin Utility, click the Database link.

  3. Click No to specify not to create a new database.

  4. In the Database Connection area, indicate the Computer Name (SQL Server computer name) and Database Name if not already available. If you reserved a copy of the IntegrityMOCRoot.xml configuration file from the previous installation and pasted it into the current installation folder, Computer name and Database name should display correctly.

  5. In the Authentication area, indicate whether Integrity should login to Microsoft SQL Server using a Windows account or the specified user ID and password. If you select the latter option, enter a user ID and password.

    1. For SQL Server Authentication, use SQL Server Management Studio to assign the db_owner user role (e.g. the domain account name). Use this domain account name to access the database.

    2. Change the connection string displayed in the setup to read as follows:

      Computer Name=machine; database=;
      Authentication=SQL Server or Windows;
      User ID=user; password=pass;

      where machine is the computer name where the SQL Server is running; user is the SQL Server account name configured in the previous step; and pass is the password for that SQL Server user account.

    3. For Windows Authentication, use SQL Server Management Studio and assign the db_owner user role for the database to the domain account to use to access the database. By default, the IntegrityDataCollector2 service runs under the SYSTEM account.

    If Microsoft SQL Server is installed as a named instance, follow the remote server name with a backslash and the instance name (for example, Server1\Instance1).

  6. Click Save. A Database Upgrade message window is displayed.

    The database upgrade to Integrity 7.3 may take over 30 minutes.

  7. Click Yes on the Database Upgrade confirmation message window to upgrade the database structure to the latest version. Depending on the size of the database, this process may take anywhere from a couple of minutes to an hour or more. A message is displayed when the upgrade completes.

    If you made changes to the database settings, a message is displayed on the Admin Utility window indicating you should stop and restart the services.

  8. Enable CLR strict security, if needed in your environment. For more information, see Updating SQL Server CLR Strict Security and Cost Threshold Settings.