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 will not be able to roll back to a previous version of your Data Repository database.

Upgrading from v2.x or v3.x to v4.x

If you upgrade with a support and upgrades package, the v2.x or v3.x activated licenses will expire and SQL Monitor will reactivate them as v4.x licenses.

If reactivation fails, or your v2.x or v3.x license does not include support and upgrades, SQL Monitor will delete the serial numbers from the Configuration > Licensing page and start a 14-day trial version of v4.x. You cannot roll back to the previous version.

If you're using v2.x or v3x without a valid support and upgrades package, we recommend that you install a trial version of v4.x on a separate machine. When you're ready to purchase v4.x licenses, you can add the support and upgrades package to make upgrading easier.

• To find your v2.x or v3.x serial numbers, go to http://www.red-gate.com/myserialnumbers and enter your email address and password.
• To purchase a v4.x license with the support and upgrades package, contact dba.info@red-gate.com.

Updating the physical path in IIS

If you've upgraded SQL Monitor from v2.x or v3.x, you'll need to change the physical path to the SQL Monitor web server configured in IIS. The path needs changing 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 details on how to do this, see Change the physical path of application content.

Installing the new version

1. Run the installer, and follow the wizard to install the Web Server and Base Monitor.
2. On the Set up Data Repository page, supply credentials with db_owner permissions under Connect to Data Repository database using:

   

   SQL Monitor will use these credentials to upgrade the Data Repository at the end of the installation process.

3. Click Next. The installer will prompt you to take a backup of the Data Repository before continuing:

   

4. When you have successfully backed up the Data Repository database, complete the rest of the wizard and click Install. All the components are installed. SQL Monitor will attempt to upgrade the database schema as soon as the web service is running successfully.
5. If you open SQL Monitor in your browser before the upgrade is complete, you will see the schema upgrade progress bar:

   

   If the upgrade is successful, your browser will then display the Enter password page or the Global Overview.

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

Error when upgrading?

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

The most common reason why the Data Repository cannot be upgraded is that the supplied account lacks the sufficient permissions to modify the database. Enter an account with db_owner permissions and click Retry Upgrade.