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.
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 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.
You should only upgrade to v4 if your current SQL Monitor license includes a valid support and upgrades package. |
If you upgrade with a support and upgrades package, the v2 or v3 licenses expire and SQL Monitor reactivates them as v4 licenses.
If reactivation fails, or the v2 or v3 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 v4. You cannot roll back to the previous version.
If your v2 or v3 license doesn't include support and upgrades, we recommend that you install a trial version of v4 on a separate machine. When you're ready to purchase v4 licenses, you can add the support and upgrades package to make upgrading easier.
The upgrade installer is the same installer you used when you first installed SQL Monitor. It replaces the current Web Server and Base Monitor, but keeps the current SQL Monitor configuration. You will need to re-enter the account credentials for the Base Monitor to connect to the Data Repository. |
To install the upgrade:
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.
SQL Monitor uses these credentials to upgrade the Data Repository after installation.
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.
If you've upgraded SQL Monitor from v2 or v3, you need to change the physical path to the SQL Monitor web server configured in IIS.
Change the path from C:\Program Files\Red Gate\SQL Monitor 2 or C:\Program Files\Red Gate\SQL Monitor 3 to C:\Program Files\Red Gate\SQL Monitor 4 .
For full instructions, see Change the physical path of application content (TechNet).
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.
The account credentials are only used to upgrade the database schema. They aren't used by SQL Monitor for anything else. |