Reputation: 715
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