Does RG SQL Scripts Manager 2 Still Support PowerShell Scripts?

Ed_Z · February 21, 2019 5:52PM

The overview for Red Gate SQL Scripts Manager version 1 mentioned T-SQL, Powershell and IronPython scripts. The overview for version 2 drops the reference to Powershell scripts. Does the product still support Powershell scripts?
If it does support Powershell scripts this extends the usefulness of the product way beyond working with SQL Server. Powershell can do system admin work, run scripts against Oracle databases via Windows utilities, etc..

squigley · February 23, 2019 1:13AM

Good Afternoon!

There should still be support for Powershell even within the later versions of Redgate SQL Script Manager.

You can see it mentioned in the following worked examples:

https://documentation.red-gate.com/ssm2/using-sql-scripts-manager/worked-example-adding-a-new-script-to-sql-scripts-manager

https://documentation.red-gate.com/ssm2/using-sql-scripts-manager/worked-example-running-a-script-and-saving-the-results

EdZ · February 25, 2019 6:23PM

Thanks, Sean. I tried out a Hello world Powershell script example from a Simple Talk article called SQL Scripts Manager with PowerShell written by William Brewer using SQL Scripts Manger version 2 and it works, so you are correct.

Does RG SQL Scripts Manager 2 Still Support PowerShell Scripts?

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk