Upgrading When Using Multiple Databases - PAS ICS Integrity - 7.3 - Installation & Upgrade - Intergraph

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. You use Admin Utility to upgrade the primary database, and you use Configuration Manager to upgrade the secondary databases. 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.

The steps for upgrading multiple databases may differ based on how your site is configured, however you should always upgrade your primary database first. If you have any questions or concerns, please contact Technical Support for assistance.

To upgrade the primary database:

1. If the 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. Open Admin Utility and 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 the primary database in the Database Name field 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.

6. Click Save. A Database Upgrade confirmation 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.

To upgrade secondary databases:

1. Open Configuration Manager on the Integrity server for the primary database. To open Configuration Manager, run the following file:

   InstallPath\DataCollector\ConfigurationManager.exe

2. Click Tools > Multiple Database Configuration.

3. For each of the secondary databases, complete the following steps:

   1. Under Connection Definition, type the connection information for the secondary database, including server name, database name, authentication type, and login credentials.

   2. Click Test Connection to make sure the connection information is correct.

   3. Click https://hexagonppm-uat.fluidtopics.net/r/en-US/Writer-s-Hub/Questions/312714?tocId=fYiTdk8Su~UZ6WwjRICrrA.

4. Click Apply, and then click OK.

5. Close Configuration Manager.