I have a production instance of SQL Server 2008 R2 running Master Data Services encrypted using using a certificate named "MDSCertP" by password "CertP1234". I have a development instance of SQL Server 2008 R2 running Master Data Services encrypted using using a certificate named "MDSCertD" by password "CertD1234". I've been asked by the the developer to restore a production copy of the MDS database to dev.
I understand that to restore successfully, I need to physically copy the certificate (.cer) and private key (.pvk) to the dev server.
Am I going to kill the dev instance by copying the prod certs? Is there a better practice to refresh the data on dev?
Thanks,