Auto updating SQL Monitor
AndrewL
Posts: 6 Bronze 1
Is anyone using PowerShell for this and if so has a working script?
Tagged:
Answers
This documentation page https://documentation.red-gate.com/sm/installation-and-setup/automated-installation-and-updates has information on automating the install of SQL Monitor using the msi files and there are some examples at the bottom of the page using PowerShell for the different components.
The installers can be downloaded from https://download.red-gate.com/checkforupdates/SQLMonitorWeb/ and then you would just need to do the extraction described near the top of the documentation page and then run msi as shown in the examples.
Hope that helps!
Kind regards,
Alex
Have you visited our Help Center?
After messing around a bit with PowerShell, one of our developers came up with this script that will download the latest installer:
<div>$awsroot = "http://redgate-download.s3.eu-west-1.amazonaws.com/"</div><div>$awsquery = "?delimiter=/&prefix=checkforupdates/SQLMonitorWeb/"</div><br><div>$xml = new-object System.Xml.XmlDocument</div><div>$xml.load($awsroot + $awsquery)</div><br><div>$sortedcontents = $xml.ListBucketResult.Contents | where-object {$_.key -notlike "*.sha256"} | sort-object -Property LastModified -Descending</div><br><div>write-host $sortedcontents[0].Key</div><br><div>$url = $awsroot + $sortedcontents[0].Key</div><br><div>$filename = $sortedcontents[0].Key.Substring($sortedcontents[0].key.lastindexof("/") + 1)</div><br><div>Invoke-WebRequest -UseBasicParsing -Uri $url -Method GET -OutFile "C:\Temp\$filename<span>"</span></div>Was wondering if we can then just execute the downloaded file so there are no prompts?
Regards
Andrew
You would need to first extract the msi's and then if you specify the various details in the command line install I think it will run with no prompts. See https://documentation.red-gate.com/sm/installation-and-setup/automated-installation-and-updates for more information on automating the install.
Kind regards,
Alex
Have you visited our Help Center?