sql-serverazuresymmetric-key

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


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 ?


Solution

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