Does Dacpack supports sqlcmd variables?

  • Article

 

 I have a got a question from a customer want to use dbdacfx provider with Web Deploy 3 which is working fine and only failing with  sqlcmd variables with below error?

 And the Question was Does Dacpack supports sqlcmd variables?

 

 

 

Ref dbDacFx Provider for Incremental Database publishing  https://www.iis.net/learn/publish/using-web-deploy/dbdacfx-provider-for-incremental-database-publishing

And the Answer is:   The dbDacFx provider does not support sqlcmd variables at this time.  This functionality might be added later, but for now you’ll have to rely on the dbsqlpackage provider for that sqlcmd variables support.