SQL Monitor Upgrade Automation - Latest Version

jpomfret7

Hey folks,

I've loosely followed the documentation here working-example-setting-up-automated-installs to get an automated process written for updating SQL Monitor.

I am curious though on how to download the latest version of the installer, according to automated-installation-and-updates it states:

The latest stable version can be downloaded from https://download.red-gate.com/SQLMonitor.exe

In using this link today I get version 12.1.45 and after the installation is complete I go to Configuration > About it shows that there is a 12.1.47 update available:

12.1.45.6551 (Updates available - SQL Monitor 12.1.47)

I can see on this page (https://download.red-gate.com/installers/SQLMonitor/2022-12-14/) there is a folder for '2022-12-14/' - when I download that it has version 12.1.46 - still can't find 12.1.47 this route.

Finally if I click on the updates available link from the Configuration > About page I get a download for SQLMonitorWeb_12.1.47. 

How do I automatically download the latest version - so as of today 12.1.47?

I also noticed that the link from the Configuration > About page contains a guid in the link - is this important to determine whether this licensed copy of SQL Monitor can be upgraded?

Thanks,

Tom_C

Hi Jess,

This can become slightly confusing but hopefully the following table provides what you need:

Believe the latest CFU is the version you're after.

I grabbed this from the following site on our documentation pages.
https://documentation.red-gate.com/sm/installation-and-setup/automated-installation-and-updates/working-example-setting-up-automated-installs

Hope this helps, please let me know if not.

jpomfret7

Hey Tom,

What does CFU stand for? Is it a pre-release version? 
Also when I click https://download.red-gate.com/checkforupdates/SQLMonitor.exe this I get a 404:



Also the second part of the question - relating to licensing - how do I know if the license is good for the next major version? Are the perpetual\subscription licenses still tied to major versions?

'I also noticed that the link from the Configuration > About page contains a guid in the link - is this important to determine whether this licensed copy of SQL Monitor can be upgraded?'

Thanks

Jess

Tom_C

Hi Jess,

CFU stands for Check For Update (can be seen in the URL of your screenshot). This will be the version that will appear in the banner of the SQL Monitor UI when a new version is released.

I'm also currently seeing that 404 error and will raise internally. If you need to grab the latest version prior to this being fixed I would recommend grabbing a version from the list here.

Live subscription licenses will be fine to update to the latest version. The link from the Configuration > About page should inform if you're not licensed/able to update but looking at your subscription you should be absolutely fine to keep updating with each release.

Hope this answers/makes sense, please let me know if not. 

Tom_C

Hi Jess,

Just a quick update, the table previously screenshotted earlier on this thread has now been updated.
https://documentation.red-gate.com/sm/installation-and-setup/automated-installation-and-updates/working-example-setting-up-automated-installs

The link for the latest CFU is now https://download.red-gate.com/checkforupdates/SQLMonitorWeb.exe

Any issues with this please let us know.