How to use multiple SQLCMD variables with SqlPackage.exe while deploying a DacPac?

Question

I am deploying a dacpac using sqlpackage.exe and need to pass SqlCMD variables for a postdeployment script in the dacpac. I found a related question here and here.

But i am getting the following error: Missing values for the following SqlCmd variables:BuildVersion Description. Description=$Description : The term 'Description=$Description' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

Please help me.

Davos · Accepted Answer · 2015-11-17 00:35:31Z

4

The correct switch for passing a SQLCMD variable to SQLPackage is like this /v:Description=$Description

Powershell quoting is a bit tricky. Here's an example for you:

https://gist.github.com/davoscollective/adf9b890984e51d8dee2

& "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\sqlpackage.exe" ` #Note this is SQL Server 2012 specific directory, alter as needed
/Action:Publish `
/SourceFile:$sourceFile `
/TargetServerName:$targetServerName `
/TargetDatabaseName:$targetDBname `
/V:SQLCMDVariable1=$SQLCMDVariable1 ` #If your project includes other database references, or pre/post deployment scripts uses SQLCMD variables
/v:SQLCMDVariable2=$SQLCMDVariable2 `

answered Nov 17, 2015 at 0:35

Davos

5,52549 silver badges70 bronze badges

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

Comments

Eugene Niemand · Accepted Answer · 2015-05-01 10:50:23Z

1

It seems like you are using Powershell to call SqlPackage based on the cmdlet error. If this is the case ensure the Dollar symbols are escaped with a inverted apostrophe i.e.

ie Description=`$Description

Could you post the full command you are passing?

answered May 1, 2015 at 10:50

Eugene Niemand

7296 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to use multiple SQLCMD variables with SqlPackage.exe while deploying a DacPac?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related