首页 > 解决方案 > sqlpackage DeployReport 生成空的xml

问题描述

我正在尝试使用sqlpackage.exewith DeployReportaction(遵循文档),但我变得空虚xml

<?xml version="1.0" encoding="utf-8"?><DeploymentReport xmlns="http://schemas.microsoft.com/sqlserver/dac/DeployReport/2012/02"><Alerts /></DeploymentReport>

我的命令是:

sqlpackage /action:DeployReport /SourceFile:"Database Services\bin\Debug\Database Services.dacpac" /TargetServerName:TESTL05,123 /TargetDatabaseName:test /OutputPath:"DeployReport.xml"

我也尝试使用这个建议的WA,但它没有帮助。:

SqlPackage.exe /action:DeployReport /TargetConnectionString:"Data Source=TEST05,123;Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False;Initial catalog=test" /SourceFile:"Database Services\bin\Debug\Database Services.dacpac" /OutputPath:"C:\git\DeployReport.xml"

顺便说一句,当我采取publish行动时,我确实在我的数据库中看到了预期的变化/你能建议这里有什么问题吗?

标签: sql-serverxmlsqlpackage

解决方案


推荐阅读