$dacpacPath = Join-Path $outputFolder "$databaseName.dacpac" Write-Output "DACPAC Path: $dacpacPath"
选择添加一个任务
选择"Visual Studio Build"作为任务选项
在"MSBuild Arguments"中输入以下内容: /p:GenerateSqlPackage=True /p:SqlPackageOutputPath= "$(Build.Repository.LocalPath)\bin$(BuildConfiguration)$(BuildProjectName).dacpac"
保存并运行Build任务
$sqlPackageArgs = "-Action Publish -SourceFile '$($outputFolder)\$($databaseName).dacpac'
-Profile '$($profileFilePath)$($profileFileName)' -TargetConnectionString '$($targetConnectionString)'
-OutputPath '$($outputFolder)'"
为解决PowerShell脚本不输出DACPAC文件的问题,您可以尝试使用以上方法进行设置和调整参数,以确保正确输出DACPAC文件。