powershell - sqlpackage.exe 将输出写入文件

Question

我正在使用该sqlpackage.exe工具发布dacpac（使用poweshell）。如何将以下命令的输出写入文件：

$sqlpackage = Start-Process -FilePath sqlpackage.exe -ArgumentList '/Action:Publish','/SourceFile:"Database Services\bin\Release\Database Services.dacpac"',"/TargetServerName:${Env}","/TargetDatabaseName:${Target}",'/p:BlockOnPossibleDataLoss=True' -wait -PassThru -Credential $Cred

输出示例：

Publishing to database 'test' on server 'TEST'.
Initializing deployment (Start)
Initializing deployment (Complete)
Analyzing deployment plan (Start)
Analyzing deployment plan (Complete)
Updating database (Start)
Update complete.
Updating database (Complete)
Successfully published database.
Time elapsed 0:03:18.51

我尝试使用Tee-Object -File "sqlpackage.log"，但输出如下所示：

Handles  NPM(K)    PM(K)      WS(K)     CPU(s)     Id  SI ProcessName                                                  
-------  ------    -----      -----     ------     --  -- -----------                                                  
              0        0          0     155.75   3608      

标签： powershellsqlpackage