Upgrading the server components from command line

ddragman

Is there an option to upgrade the server components of SQL Backup from command line? I have found "Installing the server components from the command line" section in SQL Backup 10 documentation, but nothing about upgrading server components from command line. 

We have multiple SQL clusters, each having multiple SQL instance roles and upgrading server components takes a lot of time. We would like to do it over command like with PS script calling SQBServerSetup.exe with 

corresponding parameters for upgrade. 

Jon_Kirkwood

Hi @ddragman

Thank you for reaching out over the Redgate forum regarding your SQL Backup query.

Installing & Upgrading server components are really the same in this context. 

Upgrading is installing a new version over the previous one, there is no need to remove the previous component prior to an install.  Your license, history & current jobs would transfer over.

 

I presume you're already familiar with this page, but it would be the best resource to get going with a CMDLine/PS automation solution.

https://documentation.red-gate.com/sbu/getting-started/installing/installing-the-server-components-from-the-command-line

 

This SimpleTalk post shows a method of using SQL Multi-Script to help install the Server Components in bulk and may be useful for your use-case.

https://www.red-gate.com/simple-talk/databases/sql-server/tools-sql-server/installing-sql-backup-on-multiple-servers-using-sql-multi-script/  

 Hope this is of help for you

ddragman

Hi @Jon_Kirkwood
Thank you for provided informations. I will try it next time when new update will be available.