0

Need help with the error while exporting Data-tier application(bacpac file).

The element Person.UidDetails.TableKey is not supported in Microsoft Azure SQL Database v12. (Microsoft.Data.Tools.Schema.Sql)

Person.UidDetails.TableKey is nothing but a OPEN SYMMETRIC KEY [Person.UidDetails.TableKey]. enter image description here

Error:

TITLE: Microsoft SQL Server Management Studio

Could not extract package from specified database. (Microsoft.SqlServer.Dac)

ADDITIONAL INFORMATION:

The element Person.UidDetails.TableKey is not supported in Microsoft Azure SQL Database v12. (Microsoft.Data.Tools.Schema.Sql)

Could I need help on this ?

Isaiyavan Babu Karan
  • 987
  • 2
  • 8
  • 17

1 Answers1

0

OPEN SYMMETRIC KEY is not supported on Azure SQL Database. Link for more details.

Abhishek
  • 2,482
  • 1
  • 21
  • 32
  • Could you suggest an alternative to it ? Check https://learn.microsoft.com/en-us/sql/t-sql/statements/create-symmetric-key-transact-sql – Isaiyavan Babu Karan Apr 03 '18 at 11:37
  • From the article `This feature is incompatible with database export using Data Tier Application Framework (DACFx). You must drop all symmetric keys before exporting.` – Abhishek Apr 03 '18 at 12:15
  • 1
    Thanks for the confirmation. I have dropped both key and certificate ; replaced with password. – Isaiyavan Babu Karan Apr 03 '18 at 17:54