sqlpackage publish fails if sqlcmd variable is not provided

Asked Oct 31 '19 at 13:48

Active Oct 31 '19 at 13:48

Viewed 382 times

I have an SQL project where I need to run certain scripts depending on the value of an SQLCMD variable When I pass the variable on sqlpackage.exe (i.e. /v:var=value) it works as expected, but when I don't pass the variable it fails instead of using the default value I set:

*** An error occurred during deployment plan generation. Deployment cannot continue. Missing values for the following SqlCmd variables:var.

Any idea how to fix this?

asked Oct 31 '19 at 13:48

Mickey Cohen

1

define variable in publish profile and pass it to the sqlpackage – Dmitrij Kultasev Nov 01 '19 at 08:46
I prefer not to use publish profiles. I need a way for a variable to be a default value or a value provided to sqlpackage – Mickey Cohen Nov 05 '19 at 12:26

sqlpackage publish fails if sqlcmd variable is not provided

0 Answers0