How do you use certificates to encrypt data from a table on database and decrypt it on another database? Does it involve master keys?
I was able to encrypt and decrypt on the same database using certificates. However when I tried to create the same certificate on a different database using a backup file I got the error message -
Please create a master key in the database or open the master key in the session before performing this operation
Do I need to create a master key on the source database and then use it on the target database as well? I'm using SQL Server 2008.
Any help is much appreciated. Thanks!