If you want to upgrade PerformanceGuard versions older than version 6.1.27 to the latest version, you need to first upgrade your old version to version 6.1.27, and then upgrade version 6.1.27 to the latest version.
Is your current PerformanceGuard version older than version 5.7.24? In that case you should not follow the procedures listed in the following. Instead you should contact CapaSystems.
IMPORTANT: We recommend that you have a PerformanceGuard consultant help you with the upgrade. Many older PerformanceGuard systems have been installed with a type of installation file that did not facilitate easy future upgrades of the PerformanceGuard databases. If you perform the upgrade yourself on such a system, you could lose your PerformanceGuard configuration settings.
Before you upgrade PerformanceGuard, make sure that you are familiar with [ Terminology and Abbreviations|_Ref-1262546846]. Also make sure that you know the hardware recommendations and software requirements.
The following describes how to upgrade all server components in your PerformanceGuard system from old versions to version 6.1.27.Follow the all of the procedures step-by-step unless you are a very experienced user.
Database-Upgrade-Scripts.zip

Prerequisites

Before the upgrade you need to have the following ready:

1. Your Windows credentials in order to access computers with PerformanceGuard installed
2. Your SQL Server administrator credentials in order to access the MS SQL-server
3. SQL Server credentials in order to access the PerformanceGuard backend server database
4. SQL Server credentials in order to access the PerformanceGuard frontend server database
5. A downloaded PerformanceGuard installation file

Stop Services

Stop the following services:

1. PerformanceGuard Backend Server
2. PerformanceGuard Web Server
3. PerformanceGuard Frontend Server

Back Up Databases

A backup is important to secure your existing databases. See Back Up Database.

Upgrade Database

If you are upgrading through multiple versions, it's sufficient to install the latest software and upgrade the database according to the following schema:

It's necessary to run all the intermediate upgrades in order to upgrade to the correct version. Apply scripts prefixed with BACKEND on the backend server, and apply scripts prefixed with FRONTEND on the frontend server.
The first BACKEND_XXXtoYYY.sql upgrade removes all stored procedures from the database, so make sure to apply the BACKEND_PROCEDURES.sql after the last BACKEND_XXXtoYYY.sql.
_XXXPatches.sql can be re-applied without any problems

All database scripts can be downloaded here.
If your current version is 5-9-16, first upgrade to 6-0-37, then upgrade to 6-1-27.
Example: Backend Server Database Upgrade

1. Open SQL Server Management Studio
2. Log in as administrator using <PGUARD_BE_DB_AUTH>
3. Open <ZIP_FILE_ROOT>\Backend Database Scripts\03-BACKEND_590to600.sql
4. Click Execute
5. Open <ZIP_FILE_ROOT>\Backend Database Scripts\04-BACKEND_600to610.sql
6. Click Execute
7. Open <ZIP_FILE_ROOT>\Backend Database Scripts\05-BACKEND_PROCEDURES.sql
8. Click Execute
9. Open <ZIP_FILE_ROOT>\Backend Database Scripts\06-BACKEND_610patches.sql
10. Click Execute

Example Frontend Server Database Upgrade

1. Open SQL Server Management Studio
2. Log in as administrator using <PGUARD_FE_DB_AUTH>
3. Open <ZIP_FILE_ROOT>\Frontend Database Scripts\02-FRONTEND_590to600.sql
4. Click Execute
5. Open <ZIP_FILE_ROOT>\Frontend Database Scripts\03-FRONTEND_600to610.sql
6. Click Execute
7. Open <ZIP_FILE_ROOT>\Frontend Database Scripts\04-FRONTEND_610patches.sql
8. Click Execute

Upgrade Services (if You Are Upgrading 5.9.x or Older)
If you are upgrading through multiple versions:

1. Back up [PerformanceGuard installation folder]\display\conf\performanceguard.xml

2. Back up [PerformanceGuard installation folder]\display\conf\pglicense.xml

3. Back up [PerformanceGuard installation folder]\display\maps*.*

4. Back up [PerformanceGuard installation folder]\notification\conf\config.properties

5. Back up [PerformanceGuard installation folder]\reports*.*

6. Remove PerformanceGuard
7. Remove Java 5 (only if you are upgrading from a version older than 6.0.x)
8. Install the newest version (remember to select custom installation because the databases already exist)
9. The services are started by the installer
10. Restore the backup files from steps 1-5 in the corresponding places in the new installation.

Upgrade Services (if You Are Upgrading 6.0 or 6.1.16)

1. Replace the file [PerformanceGuard installation folder]\notification\backend.jar with <ZIP_FILE_ROOT>\notification\backend.jar

2. Replace the file [PerformanceGuard installation folder]\collector\frontend.jar with <ZIP_FILE_ROOT>\collector\frontend.jar

3. Replace the file [PerformanceGuard installation folder]\display\display.war with <ZIP_FILE_ROOT>\display\display.war

4. Replace the file [PerformanceGuard installation folder]\display\console.war with <ZIP_FILE_ROOT>\display\console.war

5. Replace the file [PerformanceGuard installation folder]\display\ral.war with <ZIP_FILE_ROOT>\display\ral.war

6. Replace the file [PerformanceGuard installation folder]\display\JettyStarter.jar with <ZIP_FILE_ROOT>\display\JettyStarter.jar

7. Delete the contents of [PerformanceGuard installation folder]\display\work

8. Delete the contents of [PerformanceGuard installation folder]\collector\cache

9. Replace the file [PerformanceGuard installation folder]\tools\servermanager\servermanager.exe with <ZIP_FILE_ROOT>\tools\servermanager\servermanager.exe

10. Delete the log files (you might want to save the log files before deleting them):

    1. [PerformanceGuard installation folder]\notification\logs*.*

    2. [PerformanceGuard installation folder]\display\logs*.*

    3. [PerformanceGuard installation folder]\collector\logs*.*

11. If you are upgrading to 6.2.x or higher

    1. Replace or add the file [PerformanceGuard installation folder]\display\dot\phantomjs.exe with <ZIP_FILE_ROOT>\display\dot\phantomjs.exe

    2. Replace or add the file [PerformanceGuard installation folder]\display\dot\phantomjs_helper.js with <ZIP_FILE_ROOT>\display\dot\phantomjs_helper.js

    3. Replace or add the file [PerformanceGuard installation folder]\display\dot\PerfCounterUtility.exe with <ZIP_FILE_ROOT>\display\dot\PerfCounterUtility.exe

12. Start the services
    1. Start the PerformanceGuard Backend service
    2. Start the PerformanceGuard Web service
    3. Start the PerformanceGuard Frontend service

Upgrading from Version 6.1.27 or Newer to the Latest Version
For information about how to upgrade from version 6.1.27 to the latest version of PerformanceGuard, see Upgrade PerformanceGuard Versions Between 6.1.27 and 6.3.104 to Latest Version.