将多个参数添加到“变量"的语法是什么?sqlpackage.exe 中的参数? [英] What is the syntax for adding multiple arguments onto the "Variables" parameter in sqlpackage.exe?

问题描述

我正在使用 SqlPackage.exe 进行部署.我已阅读此处的文档SqlPackage.exe 的用法.

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:

为特定于动作的变量指定一个名称值对；{变量名}={值}.DACPAC 文件包含有效 SQLCMD 变量的列表.如果没有为每个变量提供值，则会导致错误.

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.

我的问题是文档没有说明如何将多个参数传递到 Variables 参数中.例如，我想这样做:

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?

推荐答案

我设法找到了一些有效的方法.

I have managed to find something that works.

sqlpackage.exe ...args 到这里.../Variables:VarToOverride=Value1/Variables:Var2ToOverride=Value2

这不是我想要的，但确实有效.

It's not exactly what I was looking for, but it works.

这篇关于将多个参数添加到“变量"的语法是什么?sqlpackage.exe 中的参数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！