Errors while Importing from BACPAC in Azure SQL DB

1
votes

I have a .bacpac file exported from SQL Server 2008. While I'm trying to import the same in my Azure SQL Server using latest SSMS, I'm thrown the below error at a specific Table.

===================================

Data plan execution failed with message One or more errors occurred. (Microsoft.SqlServer.Dac)

One or more errors occurred. (mscorlib)

===================================

One or more errors occurred.

One or more errors occurred.

The given key was not present in the dictionary. (mscorlib)

===================================

Can somebody please help me on this?

Many Thanks, Suhail

1
sql-serverazureimporterrorazure-sql-databasebacpac
Is it possible that your database changed (data added/removed) while the BACPAC file was being exported? - Tim
No! I did export it in a separate session several times though. - Suhail
Did you got the resolution for the same? - Sagar Solanki

1 Answers

0
votes

Are any of the tables or columns named with unusual characters? Such as a table with a column named something like '[columnname].columnname' instead of just 'columnname'? That turned out to be the issue in our case - rename the column to a more standard name.