Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Best way to copy an Azure SQL Server database with encrypted columns from one subscription to another

What is the best and easiest way to copy an Azure SQL Server database with encrypted columns from one subscription to another.

Tried to export to a .bacpac file but it errors with

SQL71626 (certificate/symmetric key is not supported in Microsoft Azure SQL Database v12)

Should I make a copy and then remove the keys before I export/import?

like image 978
RGI Avatar asked Nov 20 '25 12:11

RGI


1 Answers

Congratulations your question is answered here:

Copy SQL database with encryption from one Azure subscription to another.

I post it as the answer and this can be beneficial to other community members.

like image 76
Leon Yue Avatar answered Nov 22 '25 02:11

Leon Yue