sqlpackage DeployReport xml corrupted

Question

Hi
I'm running the below command using powershell script:

$sqlpackagereport = Start-Process -FilePath sqlpackage.exe -ArgumentList '/Action:DeployReport','/SourceFile:"Database Services\bin\Release\Database Services.dacpac"',"/TargetServerName:${Env}","/TargetDatabaseName:${Target}","/OutputPath:Report.xml" -wait -PassThru -Credential $Cred
$sqlpackagereport.WaitForExit()
$sqlpackagereport

but when I'm trying to open Report.xml in the server, I get this exception:

    This XML file does not appear to have any style information associated with it. The document tree is shown below.
<DeploymentReport xmlns="http://schemas.microsoft.com/sqlserver/dac/DeployReport/2012/02">
<Alerts/>
...
</DeploymentReport>

Answer 1

Hi @arielman2304 ,

> "/OutputPath:Report.xml"

I am not familiar with powershell. Did the file location for storing XML report is correct? The location did not point a folder, only report file name.

OutputPath – The path where the XML report will be stored after it is generated

If we using cmd, below is an example to general XML report.

You can try to use cmd to explore actions and tasks in the SQLPackage, please refer to the blog Exploring actions and tasks in the SQLPackage Utility to get detail example information.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 2

Hi @arielman2304 ,

> I just tested it without powershell, and I got empty xml

Using cmd?

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

Why the source file location and output path location did not point to a folder? Try to add like C:\ or D:\ in the file location.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.