L G

L G

  • NA
  • 1
  • 1.2k

Using Master Keys and Certificates

Feb 5 2014 6:20 PM
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!