CODEWITHSUNDEEP
sql-serverexportbacpac
Emile Cloete
Emile Cloete

Reputation: 163

Unsupported elements in SQL bacpac export

I am trying to create a bacpac file of a SQL Server database hosted on GearHost to migrate to an elastic pool in Azure using "Export Data-tier Application" in SSMS.

I have tried many solutions found on the web to no avail. The below error still persists. How can I solve it to extract the bacpac successfully?

One or more unsupported elements were found in the schema used as part of a data package. Error SQL71626: The element Certificate: [Certificate1] is not supported in Microsoft Azure SQL Database v12.

Error SQL71626: The element Symmetric Key: [SymmetricKey1] is not supported in Microsoft Azure SQL Database v12. (Microsoft.SqlServer.Dac)

Upvotes: 3

Views: 5759

Answers (1)

PankajSanwal
PankajSanwal

Reputation: 1029

This is because Azure SQL db does not support a lot of on-prem objects and features and symmetric key and certificates are one of them. You got to run below drop commands on your source db before exporting it to bacpac file.

-----Drop Keys and Certificate----------------------

DROP SYMMETRIC KEY SymmetricKeyName;  
GO
DROP CERTIFICATE ISFCertificate  
go
DROP MASTER KEY
Go

Upvotes: 0

Related Questions