How to update dacpac version during build process to be build number of the queued build?

Question

I am trying to update the version element in the DacMetadata.xml file of a .dacpac to match the build number of the build where the .sqlproj is being built. I would prefer to do this in PowerShell, but can do it in C# if necessary.

I am using on-prem TFS 2018 and the vNext build.

score 0 · Answer 1 · answered Mar 05 '20 at 06:41

0

There is already an extension exists to version dacpac, you can check and test it:

https://marketplace.visualstudio.com/items?itemName=richardfennellBM.BM-VSTS-Versioning-Task

answered Mar 05 '20 at 06:41

Cece Dong - MSFT

29,631
1
24
39

Have you checked the extension? Is it helpful? – Cece Dong - MSFT Apr 01 '20 at 09:31

How to update dacpac version during build process to be build number of the queued build?

1 Answers1