Upgrading to a later version of SQL Monitor retains your current monitoring data in the Data Repository. SQL Monitor updates the Data Repository database schema to the newer version during installation.

How do I know when an upgrade is available?

When an upgrade is available, SQL Monitor displays a message above the product name banner:

Click the link for information about the upgrade, and a link to download the installer.

Before upgrading

Before you upgrade to a later version, we recommend that you back up your current Data Repository. Once the upgrade is completed, you won't be able to roll back to a previous version of your Data Repository database.

Locating the SQL Monitor Repository

If you can't find your SQL Monitor repository database, see Locating the SQL Monitor database.

Upgrading to SQL Monitor v9

If you upgrade with a support and upgrades package, the v2, v3, v4, v5, v6, v7 or v8 licenses expire and SQL Monitor reactivates them as v9 licenses. 

If reactivation fails, or the v2, v3, v4, v5, v6, v7 or v8 license doesn't include support and upgrades, SQL Monitor deletes the serial numbers from the Configuration > Licensing page and starts a 14-day trial of v9. You cannot roll back to the previous version.

If your v2, v3, v4, v5, v6, v7 or v8 license doesn't include support and upgrades, we recommend that you install a trial version of v9 on a separate machine. When you're ready to purchase v9 licenses, you can add the support and upgrades package to make upgrading easier.

• To find your serial numbers, go to http://www.red-gate.com/myserialnumbers and enter your email address and password.
• To find out if your license includes a valid support and upgrade package, go to http://www.red-gate.com/upgrade and enter your serial number.
• To purchase a v9 license with the support and upgrades package, contact sqlmonitor@red-gate.com.

Installing the upgrade

To install the upgrade:

1. Download the installer to the machine that hosts the SQL Monitor Web Server.
2. Run the installer, and follow the wizard to re-install the Web Server and Base Monitor.

3. On the Set up Data Repository page, the Data Repository details are entered for you. You don't need to set up the Data Repository again.

4. Under Connect to Data Repository database using, enter the credentials for an account with db_owner permissions.

   

   SQL Monitor uses these credentials to upgrade the Data Repository after installation.

5. Click Next. The installer prompts you to take a backup of the Data Repository before continuing:

   

6. When you've backed up the Data Repository database, complete the rest of the wizard and click Install. 
   All the components are installed. SQL Monitor will try to upgrade the database schema as soon as the web service is running.
7. If you open SQL Monitor in your browser before the upgrade is complete, you'll see the schema upgrade progress bar:

   

   If the upgrade is successful, your browser displays the Enter password page or the Global Overview.

   If the upgrade is not successful, an error page is displayed.

Updating the physical path in IIS

If you've upgraded SQL Monitor from v2, v3, v4 or v5, you need to change the physical path to the SQL Monitor web server configured in IIS.

Change the path to C:\Program Files\Red Gate\SQL Monitor.

For full instructions, see Change the physical path of application content (TechNet).

Upgrading errors

If you encounter an error when upgrading, refer to the error message highlighted in the box. These error messages are returned by SQL Server, not SQL Monitor.

The most common reason for a failed Data Repository upgrade is that the account entered doesn't have sufficient permissions to modify the database. Enter an account with db_owner permissions and click Retry Upgrade.