Upgrading the 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
Best Answer
-
Jon_Kirkwood Posts: 395 Silver 5
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.
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.
Hope this is of help for you
Jon Kirkwood | Technical Support Engineer | Redgate Software
Answers
Thank you for provided informations. I will try it next time when new update will be available.