How can we help you today? How can we help you today?

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

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!
jscott981
0

Comments

5 comments

Sort by
  • PeterG
    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.
    PeterG
    0
  • jscott981
    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
    0
  • PeterG
    Correct, you only need the plugins from the marketplace.
    PeterG
    0
  • jscott981
    Thank a lot for the answers.
    jscott981
    0
  • way0utwest
    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.
    way0utwest
    0

Add comment

Please sign in to leave a comment.