SQL Change Automation: Build/Release plugins & VSTS Hosted Agent

jscott981 · August 28, 2018 1:45PM

Hi, all!
Is it possible to use SQL Change Automation: Build/Release plugins with Windows-Hosted Agent on VSTS?

As I found somewhere on the website that it is possible without additional installing the DLM Automation (SQLToolbelt), I'm wondering how it is possible - software, DLM Automation, should be installed on the same machine where the agent is installed - in this case it is somewhere in cloud - VSTS machine, which we don't have access to.

Can someone explain me how this works? Can I use hosted agents or have to use so-called remote agents?

Thanks!

PeterG · August 28, 2018 3:55PM

Correct, you only need the plugins from the marketplace.

PeterG · August 28, 2018 3:05PM

There is a PowerShell gallery package for SQL Change Automation (https://www.powershellgallery.com/packages/SqlChangeAutomation/) this can be installed for just the current user. The plugins will install from there, meaning VSTS hosted agents can download and use the software.

In short yes you can use hosted agents, we pull down the package as part of the build/release.

jscott981 · August 28, 2018 3:49PM

Does it mean that if I am using VSTS plugins, all I need to 'install' are plugins from marketplace and not the software itself (because plugins will install needed PowerShell package which actually does the job)?

jscott981 · August 28, 2018 4:04PM

Thank a lot for the answers.

way0utwest · August 29, 2018 11:35PM

Yes, the hosted agent needs to install the plugins. The hosted agent is rebuilt each time from scratch and doesn't include the SCA cmdlets.

SQL Change Automation: Build/Release plugins & VSTS Hosted Agent

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk

SQL Change Automation: Build/Release plugins &amp; VSTS Hosted Agent

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk

SQL Change Automation: Build/Release plugins & VSTS Hosted Agent