Good day everyone,
I am importing .bacpac db file into my dev environment to debug some integration issue after updating to 10.0.30.
I am using the SqlPackage wich, had always work for me in the past. I got stocked with the error below:
*** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Violation of PRIMARY KEY constraint 'PK__CLASSIDT__D9C1FA0108BEBA49'. Cannot insert duplicate key in obje
ct 'dbo.CLASSIDTABLE'. The duplicate key value is (AADAuthenticationMonitoringAndDiagnostics).
The statement has been terminated.))).
What I have done so far?
I queried CLASSIDTABLE and deleted the record with "AADAuthenticationMonitoringAndDiagnostics".
After that, I retried the import and now got the following error.
*** Error importing database:Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database.
Error SQL0: Data cannot be imported into target because it contains one or more user objects. Import should be performed against a new, empty database.
Is there a way, I can skip the skip the object importing part and move straight to the updating the table?
Thank you.
