Build and generate script for SSDT project using command line tools

Question

I am trying to achieve following workflow using command line:

Build the project using specific variables overriding via command line (for example I have $(buildVersion) variable in publish config that has some value. I would like to override the $(buildVersion) by entered value command line. The output of this step is dacpac file
Generate the publish script based on the generated dacpac file and the actual database

I tried to use both SqlPackage.exe and MSBuild.exe tools. However I can't get desired effect as:

I can't find the way how to build project with SqlPackage
I can't find the way how to pass variables to MSBuild

What I can now:

I can build the project using MSBuild
I can generate the publish script with SqlPackage

Gavin Campbell · Accepted Answer · 2017-08-30 16:43:22Z

3

The stuff in a publish profile for a database project doesn't affect the build step where the dacpac is created, after all you can have as many publish profiles as you like for a single project.

When generating the publish script with sqlpackage.exe, you can pass variables like sqlpackage.exe /action:script /sourcefile:mydacpac.dacpac /v:BuildNumber=xyz

answered Aug 30, 2017 at 16:43

Gavin Campbell

8366 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dmitrij Kultasev Over a year ago

Ohh, I didn't think about the thing that variables values are not stored in the dacpac ... thanks

Collectives™ on Stack Overflow

Build and generate script for SSDT project using command line tools

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related