user5855178
user5855178

Reputation: 715

How to show detailed diagnostic information when publishing dacpac with dacservices object?

How to show detailed diagnostic information when publishing dacpac with dacservices object?

SqlPackage.exe has a Diagnostics switch for detailed output of the publish operation.

/Diagnostics:   /d  {True|False}    Specifies whether diagnostic logging is output to the console. Defaults to False.

My question is how do I enable this for dacservices instead of using the exe?

The deploy and publish methods below do not seem to offer a parameter for this:

public Microsoft.SqlServer.Dac.PublishResult Publish (Microsoft.SqlServer.Dac.DacPackage package, string targetDatabaseName, Microsoft.SqlServer.Dac.PublishOptions publishOptions);

public void Deploy (Microsoft.SqlServer.Dac.DacPackage package, string targetDatabaseName, bool upgradeExisting = false, Microsoft.SqlServer.Dac.DacDeployOptions options = default, System.Threading.CancellationToken? cancellationToken = default);

This question would further apply for using Sql Server Data tools inside visual studio as a publish profile.. there seems to be no means to enable detailed diagnostic information to be output during a db publish operation.

Upvotes: 0

Views: 336

Answers (0)

Related Questions