[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Create Symmetric Key not supported for the targeted platform

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
Tips
Troubleshooting
Tuning

Create Symmetric Key not supported for the targeted platform.


Applies to: Azure SQL Database, Visual Studio 2017, SQL Server Data Tools.
 

Problem Description.
 

Let's say you have a database project on Visual Studio with the target platform set to a local SQL Server 2014.You want to migrate to Azure SQL Database, for that reason you change the target platform to Microsoft Azure SQL Database V12 but you may receive the following error:


SQL70015: Statement 'CREATE SYMMETRIC KEY' is not supported for the targeted platform.


However, the CREATE SYMMETRIC KEY is supported on Azure SQL Database as stated by this documentation.



Cause.


The potential of losing encrypted or signed data when is exported to another database because symmetric key and asymmetric key objects cannot be exported have complicated the support of certificates and symmetric keys on SQL Server Data Tools (SSDT).

 

Support for CREATE CERTIFICATE and CREATE SYMMETRIC KEY is expected on a future version of SSDT.



Workaround.


Set Target platform to SQL Server 2014 and then deploy with the "Allow incompatible platform" option set.

 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.