SqlPackage DeployReport returning an empty report

Question

SqlPackage DeployReport returning an empty report

arielman2304 676

Jun 14, 2021, 9:45 AM

Hi,
I'm running the command:

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

But I'm getting empty xml:

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

I saw similar question here, but the solution didn't help me

2 answers

Your answer

Answer 1

CarrinWu-MSFT 6,891

Jun 15, 2021, 2:37 AM

Hi @arielman2304 ,

Welcome to Microsoft Q&A!

It seems that you didn't Specify a clear path. Please refer to this blog, see below:

sqlpackage  
/action:DeployReport  
/SourceFile:”C:\temp\SnapshotV1.dacpac”  
/TargetFile:”C:\temp\SnapshotV2.dacpac”  
/TargetDatabaseName:SQLShackDemoDB  
/OutputPath:”C:\temp\DeployReport.xml”

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

arielman2304 676

Jun 15, 2021, 11:01 AM

I tried the below but still gets empty:

sqlpackage /action:DeployReport /SourceFile:"Database Services\bin\Debug\Database Services.dacpac" /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" /OutputPath:"C:\git\Report.xml"

CarrinWu-MSFT 6,891 Reputation points

Jun 16, 2021, 1:24 AM

Sorry about that I don't familiar with the command line of SqlPackage. But I do some research, I found that every SouceFile and OutputPath have a complete path, I didn't see the disk you specified, so could you please try the script like below:

sqlpackage /action:DeployReport /SourceFile:"C:\Database Services\bin\Debug\Database Services.dacpac" /TargetServerName:TEST05,123 /TargetDatabaseName:test /OutputPath:"C:\DeployReport.xml"
arielman2304 676 Reputation points

Jun 16, 2021, 5:47 AM

Tnx but it didn't help... still getting the same results

Answer 2

CarrinWu-MSFT 6,891

Jun 16, 2021, 6:28 AM

Hi @arielman2304 ,

Have you try to add /TargetUser: and /TargetPassword: on command line? Please refer to this blog and this link, see below:

/TargetUser: For SQL Server Auth scenarios, defines the SQL Server user to use to access the target database.

/TargetPassword: For SQL Server Auth scenarios, defines the password to use to access the target database.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

arielman2304 676 Reputation points

Jun 16, 2021, 8:41 AM

I'm not sure it required as other actions works properly with the same syntax like Publish and Script. I tried also to add the flag of AllowIncompatiblePlatform=True, but still result is the same
CarrinWu-MSFT 6,891 Reputation points

Jun 17, 2021, 1:46 AM

I check all the value and description of parameters which you needed. Except /Action:, all the other values are {sthring}, maybe you need add double quotation marks for those parameter.

arielman2304 676

Jun 17, 2021, 7:40 PM

I will try to run this way, and if it doesn't work I'm giving up :)

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

Tom Phillips 17,761 Reputation points

Jun 17, 2021, 7:51 PM

Do you have the latest version of SQL package installed?

https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver15

The report you posted is just empty. If there are no changes, the report would be empty.

I assume "123" is not really your port number for the server.

Share via

SqlPackage DeployReport returning an empty report

2 answers

Your answer