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.

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:

• Your Windows credentials in order to access computers with PerformanceGuard installed
• Your SQL Server administrator credentials in order to access the MS SQL-server
• SQL Server credentials in order to access the PerformanceGuard backend server database
• SQL Server credentials in order to access the PerformanceGuard frontend server database
• A downloaded PerformanceGuard installation file

Stop Services

Stop the following services:

• PerformanceGuard Backend Server
• PerformanceGuard Web Server
• 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:

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.