I have 2 sql server 2005 databases on separate servers. One database is production and the other is a datawarehouse. The production server has encypted data columns within the tables. When that data is copied over to the data warehouse, I believe the encryption master key is no longer valid on the datawarehouse server.
How do I ensure that the encrypted data can be decrypted in the warehouse?
Do I unencrypt and re-encrypt? Or is there a better way?