Notes
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de vous connecter ou de modifier des répertoires.
L’accès à cette page nécessite une autorisation. Vous pouvez essayer de modifier des répertoires.
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.