Automatic Version increment on Data-Tier Applications In the project settings of a database project I can set the version number form my data-tier application, however setting this manually is a bit inefficient. I would like to automatically increment the build number, as with other VS projects. How can this be done ? At the same time I would like to see this version number in the generated dacpac file.
I found this forum thread had an answer that worked well: Automatic Version increment on Data-Tier Applications

Minimum steps are:


Create Properties\AssemblyInfo.cs if it doesn't already exist, and make sure it's included in the project and contains at least this code: using System.Reflection; [assembly: AssemblyVersion("1.0.*")] Or however you want your version number to go.
Edit the *.sqlproj file in an outside editor (notepad etc) and add the following XML:


    &lt;Target Name="SetDacVersionToAssemblyVersion" AfterTargets="CoreCompile"&gt;
        &lt;GetAssemblyIdentity AssemblyFiles="$(IntermediateTargetFullFileName)"&gt;
            &lt;Output TaskParameter="Assemblies" PropertyName="IntermediateTargetAssembly" /&gt;
        &lt;/GetAssemblyIdentity&gt;
        &lt;PropertyGroup&gt;
            &lt;DacVersion&gt;$(IntermediateTargetAssembly.Split(',')[1].Split('=')[1])
            &lt;/DacVersion&gt;
        &lt;/PropertyGroup&gt;
        &lt;Message Text="DacVersion set to $(DacVersion)" Importance="high" /&gt;
    &lt;/Target&gt;