ssmssqlpackagebacpacdata-tier-applications

Sqlpackage throwing error without details

I am currently working on an application to easily restore a bacpac file. Unfortunately i have the following issue: Sqlpackage throws a error that it cannot import a database because it contains one or more user objects, but when i restore the bacpac using SSMS, then it gives me the detailed error message: Invalid column IncSetCost.

Is it possible that sqlpackage can give me the same error message (example: using a extra command/switch) without using SSMS for detailed error message or is there a orther utility that can restore a bacpac with more detailed error message.

Error message sqlpackage: enter image description here Error message SSMS (import data-tier) enter image description here

Greetings, Stefan

Solution

  • Check below 2 options:

    This will help exporting detailed diagnostic information to console or to a file.

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

    /DiagnosticsFile: /df {string} Specifies a file to store diagnostic logs.

    For older versions of sqlpackage.exe this should work.