Post reply

copy encrypted(Binary Data) values from one database to another database

  • July 27, 2009 at 10:17 am

    #132325

    Hi Guys,

    Can anyone tell me how to copy the encrypted(Password) values from one database to another database.We are using symmetric key algorithm to encrypt the passwords in user table.Now we want to copy the user table data including encrypted password values in to another database.

    Thanks,

    Ram.

  • July 27, 2009 at 1:52 pm

    #1030725

    backup and restore the database master key to the destination database. Depending on the encyrption methodology you might have to restore the service master key to the destination server.

    The probability of survival is inversely proportional to the angle of arrival.

  • July 27, 2009 at 6:56 pm

    #1030798

    Thanks for sending reply,is it possible to export and import the encrypted data values or copy and paste the encrypted values.

    Can you guys,please send me an script to backup and restore the database master key.

  • July 27, 2009 at 7:24 pm

    #1030801

    it's in books oline:

    BACKUP MASTER KEY

    RESTORE MASTER KEY

    http://technet.microsoft.com/en-us/library/ms174387.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • July 28, 2009 at 9:35 am

    #1031123

    Thanks for your suggestion,henforth i will follow the correct way to post my queries.

Viewing 5 posts - 1 through 4 (of 4 total)

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