Deploying to On-Premises Servers with VSTS

Sign in to queue

The Discussion

  • User profile image
    Andux

    Great intro, very informative.

    Does this work from on-prem build servers?

  • User profile image
    Damovisa

    Are you talking about using Release Management in TFS rather than VSTS? If so - it will work if you're on a recent-enough version (the docs say TFS 2018).

    If you're talking about whether you can do this from VSTS/TFS Build (rather than Release), the answer is no. Deployments should really be handled with Release Management (or another tool if you like) rather than Build - separating the creation of an artifact and actually deploying and promoting it between environments is really important in a good DevOps strategy. There's some good information about why on the 12 Factor App page.

  • User profile image
    Joey Eng

    I'm not seeing the SQL Server Database deploy task in VSTS. Is it just using SqlPackage.exe behind the scenes? If so can you pass SqlPackage.exe parameters like exclude users?

  • User profile image
    Joey Eng

    Whoops, ignore my last question. I was looking at build definition tasks instead of release. And I see the arguments section to pass parameters to SqlPackage.exe.

Add Your 2 Cents