Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Import &Export the symmetric key encrypted fields from one database to another database Expand / Collapse
Author
Message
Posted Thursday, January 28, 2010 9:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 28, 2010 9:40 AM
Points: 1, Visits: 3
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
Post #855407
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse