0

I'm trying to import a .bacpac created from SQL Azure into a SQL Server 2016 server that has no existing databases beforehand. It will run but run into issues such as:

Unhandled Exception: Microsoft.SqlServer.Dac.Data.DataException: Data plan execution failed with message One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_ITIssue'. Cannot insert duplicate key in object 'dbo.ITIssue'.

I have verified the primary key is unique on the source database. It will also throw errors for some foreign key relationships. It stops importing the table it's on and continues to the next one.

0

Please download the latest version of SSMS to import the dacpac.

Download it from here.

Hope this helps.

Regards,

Alberto Morillo

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.