Import &Export the symmetric key encrypted fields from one database to another database

  • 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

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply