# Upgrade to Version 6.1.27 from Older Versions

> Upgrade PerformanceGuard versions older than 6.1.27 by going through version 6.1.27 first.

Source: https://docs.capaone.com/performanceguard/installation/install-performanceguard-server-8-1-or-newer/upgrade-version-7-0-or-newer-to-version-7-6/upgrade-to-version-6-1-27-from-older-versions/  
Product: PerformanceGuard — a separate CapaSystems product; do not apply this page to any other.

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.

:::caution
**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.
:::

:::caution
**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.
:::

:::tip
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](/performanceguard/installation/install-performanceguard-server/hardware-recommendations/) and [Software Requirements](/performanceguard/installation/install-performanceguard-server/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:

- 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](/performanceguard/administration/more-setup/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:  
![](/attachments/performanceguard/dc0b1980-9358-45fc-b1de-d4d3fda40072.png)

:::caution
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.
:::

:::caution
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

| **Installed Version**       | **Script for Upgrading to Next Version**                                                                                                                                  |
|:----------------------------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| **Latest PerformanceGuard** | Follow instructions in [Upgrade Versions Between 6.1.27 and 6.3.104 to Latest Version](Upgrade%20Versions%20Between%206.1.27%20and%206.3.104%20to%20Latest%20Version.md). |
| **6-1-27**                  | BACKEND\_610Patches.sql  FRONTEND\_610Patches.sql                                                                                                                         |
| **6-0-37**                  | BACKEND\_600to610.sql  FRONTEND\_600to610.sql                                                                                                                             |
| **5-9-16**                  | BACKEND\_590to600.sql  FRONTEND\_590o600.sql                                                                                                                              |
| **5-8-11**                  | BACKEND\_58xto590.sql                                                                                                                                                     |
| **5-7-24**                  | BACKEND\_570to580.sql  FRONTEND\_570o580.sql                                                                                                                              |

All database scripts can be downloaded [Upgrade to Version 6.1.27 from Older Versions](/performanceguard/installation/install-performanceguard-server-8-1-or-newer/upgrade-version-7-0-or-newer-to-version-7-6/upgrade-to-version-6-1-27-from-older-versions/).  
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 Versions Between 6.1.27 and 6.3.104 to Latest Version](Upgrade%20Versions%20Between%206.1.27%20and%206.3.104%20to%20Latest%20Version.md).
