support SqlCmdVars when using MsDeploy dbDACFx provider
When MsDeploy 3.0 was released, it came with the new dbDACFx provider to do incremental database deployments based on dacpacs (created with Sql Server Data Tools aka .sqlproj). I would like to be able to use SqlCmdVars (supported by sqlpackage.exe) when creating msdeploy packages. These sqlCmdVars should be set using the Parameters.xml file so parameteres can be entered when using the IIS Manager Import Package wizard, the same way as fx appSettings can be entered.
Thanks for taking the time to share this suggestion. This item has been around for a couple of versions of Visual Studio and we haven’t acted on it. Looking at the VS “15” plans, we’re not going to take action on this item, so we’re going to close it. If the suggestion is still relevant, please either take a look to see if there’s another suggestion that’s similar that you can vote on, or open a new suggestion.
- The Visual Studio Team
Peter T. LaComb Jr. commented
This absolutely needs to get fixed. Considering all the problems with the dbSqlPackage and sqlpackage.exe.