sql-server - sqlpackage表列表

Question

我正在尝试使用动态表列表从 powershell 运行 sqlpackage，但在将表列表放入 var 时出现错误。我需要将表列表放入一个 var 中，因为它将动态生成。

下面的代码工作得很好:

.\sqlpackage.exe `
    /a:Export `
    /scs:"Data Source=$($ServerName);Initial Catalog=$($SourceDbName);User ID=my_user;Password=my_password" `
    /tf:$BacPacFileName `
    /p:TableData=[dbo].[QRTZ_CALENDARS] /p:TableData=[dbo].[QRTZ_SCHEDULER_STATE]

但是，当我将表列表放入 var 时，它失败了:

$tableList = "/p:TableData=[dbo].[QRTZ_CALENDARS] /p:TableData=[dbo].[QRTZ_SCHEDULER_STATE]"

.\sqlpackage.exe `
    /a:Export `
    /scs:"Data Source=$($ServerName);Initial Catalog=$($SourceDbName);User ID=my_user;Password=my_password" `
    /tf:$BacPacFileName `
    $($tableList)

错误文本:

.\sqlpackage.exe : Argument 'TableData' has an invalid value:'[dbo].[QRTZ_CALENDARS] /p:TableData=[dbo].[QRTZ_SCHEDULER_STATE]'.Table to extract data from must be specified using the two-part tablename format: schema_name.table_identifier.At line:1 char:1+ .\sqlpackage.exe `+ ~~~~~~~~~~~~~~~~~~    + CategoryInfo          : NotSpecified: (Argument 'T...ble_identifier.:String) [], RemoteException    + FullyQualifiedErrorId : NativeCommandError  Incorrect syntax near /.

Answer 1

$tableList 的值作为单个参数 传递，而不是参数列表。你实际上想在这里做的是splatting :

$cs = "Data Source=${ServerName};Initial Catalog=${SourceDbName};" +
      'User ID=my_user;Password=my_password'

$params = '/a:Export',
          "/scs:`"${cs}`"",
          "/tf:${BacPacFileName}",
          '/p:TableData=[dbo].[QRTZ_CALENDARS]',
          '/p:TableData=[dbo].[QRTZ_SCHEDULER_STATE]'

.\sqlpackage.exe @params