How to export DB to other server that is encrypted in SQL 2008 R2?

This is using 2 MS SQL 2008 R2 servers. On DB server 1, there is a database that is encrypted. My boss wants us to move this DB to another server - DB server 2. I am clear about the migration - use export and import; but, the problem is since the db is encryption, what should I do to it ? Please show step-by-step.

Thanks in advance.
MezzutOzilAsked:
Who is Participating?
 
MezzutOzilConnect With a Mentor Author Commented:
Hi all,

1.      Rename the 2 Key files extention in the folder D:\keys to
                      ExportedPRODDBCert
                      PRODDB_Key

2.      Run the below query in the master DB

                     CREATE CERTIFICATE PRODDBCert
                     FROM FILE='D:\keys\ExportedPRODDECert'
                     WITH PRIVATE KEY(
                     FILE='D:\Keys\RPODDB_Key', DECRYPTION BY PASSWORD='P@ssword')
0
 
MezzutOzilAuthor Commented:
It works
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.