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

0
votes

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 ?

1
sql-serverazuresymmetric-key

1 Answers

0
votes

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