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?
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With