Hey guys,
We are facing some problem while exporting the encrypted (symmetric keys) fields data from one database to another database on sqlserver 2005
We are having one user table with username and password.
The password field is encrypted with symmetric key - Active directory certificate and master key are also password protected.
we have inserted username and passwords in to table and we are trying to export the user table data from staging to production server,but master and symmetric keys are not opening in destination server.The password is becoming null and importing the data into destination server.
Thanks
Ram