Sqlpackage throwing error without details

774 views Asked by At

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

1

There are 1 answers

0
PankajSanwal On BEST ANSWER

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.