What is the syntax for adding multiple arguments onto the "Variables" parameter in sqlpackage.exe?

Question

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:

Specifies a name value pair for an action specific variable; {VariableName}={Value}. The DACPAC file contains the list of valid SQLCMD variables. An error will result if a value is not provided for every variable.

My problem is that the documentation does not say how to pass multiple arguments into the Variables parameter. For example, I want to do this:

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

Does anyone know the syntax for this?

gregpakes · Accepted Answer · 2013-03-19 14:55:08Z

31

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.

answered Mar 19, 2013 at 14:55

gregpakes

4,5651 gold badge31 silver badges44 bronze badges

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

2 Comments

Oren Hizkiya Over a year ago

Does anyone else feel it is odd that a flat to be used for a single variable is written in the plural? /Variable:Foo=Bar would have made more sense.

reckface Over a year ago

This worked for me, and /v:var1=val1 /v:var2=val2 /v:var3=val3 also works /v: is a shortcut for /variables:

jamiet · Accepted Answer · 2013-04-03 08:45:17Z

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.

answered Apr 3, 2013 at 8:45

jamiet

12.7k22 gold badges117 silver badges204 bronze badges

Comments

Amol R · Accepted Answer · 2018-10-03 04:43:03Z

1

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.

answered Oct 3, 2018 at 4:43

Amol R

871 silver badge9 bronze badges

Collectives™ on Stack Overflow

What is the syntax for adding multiple arguments onto the "Variables" parameter in sqlpackage.exe?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related