Home Forums SQL Server 2008 SQL Server 2008 - General How to copy encrypted data to another database RE: How to copy encrypted data to another database

  • February 7, 2018 at 8:05 am

    #1978899

    Bert-701015 - Wednesday, February 7, 2018 7:36 AM

    if your database has already been restored you should be able
    OPEN MASTER KEY DECRYPTION BY PASSWORD = 'MyStrongPassword';
    ALTER MASTER KEY
        ADD ENCRYPTION BY SERVICE MASTER KEY;
    CLOSE MASTER KEY;

    where "MyStrongPassword" is the pw from the source database

    Do I have to re-encrypt my DBMK with SMK? if so I am assuming that's because no two databases can have exactly the same DBMK. But then that would beg the question that when my DBMK changes then my symmetric key will stop working because now my symmetric key is dealing with a different DBMK which was used to create it. And if all i have said is true ( I hope I am wrong) then i think i can only encrypt new data but cannot decrypt restored data as my DBMK is now different?????????????

    Regards,

    Waqar