What Is The Syntax For Adding Multiple Arguments Onto The "variables" Parameter In Sqlpackage.exe?

I am using SqlPackage.exe for my deployment. I have read the documentation here for the usage of SqlPackage.exe. The documentation only states the synax for one variable: Specifi

Solution 1:

I have managed to find something that works.

sqlpackage.exe ...args go here... /Variables:VarToOverride=Value1 /Variables:Var2ToOverride=Value2

It's not exactly what I was looking for, but it works.

Solution 2:

Did you try separating using semi-colons rather than commas. i.e.:

sqlpackage.exe ...args go here...  /Variables:VarToOverride=Value1;Var2ToOverride=Value2

Your other option is to use Publish Profile files.

Solution 3:

You can specify the multiple arguments as below. /p:CreateNewDatabase=True /p:Storage=File /p:DatabaseEdition=Standard /p:DatabaseServiceObjective=S3 /p:DatabaseMaximumSize=50 Giving space after each argument.