First published on MSDN on Oct 03, 2017
In the previous
we manage to import into Azure SQL Database a certificate so we could improve the security of our system.
But there can be situations where we need to backup the certificate to be used in another Azure SQL Database or for any other reason.
So how can we backup an already existing certificate in our Azure SQL Database?
We can execute this script and we will get the SQL query that we can store and execute to recreate the certificate.
declare @pwd VARCHAR(Max)
declare @cer VARBINARY(MAX)
declare @pvk VARBINARY(MAX)
declare @certName sysname