I would like some advice on cell based encryption please.
I have transferred a database which uses a certificate to encrypt certain data from a live server to a newly built server.
Now that the database is on a new server, the DECRYPTBYCERT function only returns null values when applied to the encrypted data. Please could someone confirm the best way to re-enable the function?
The steps I think I should take are:-
1. Backup Database Master Key on original server
2. Transfer backup to new server
3. Restore DMK using Server Master Key
Any help would be most appreciated.