locked
Migrate/Backup Symmetric key from one server to another RRS feed

  • Question

  • Hi everyone ,

    I have a problem about migrate or backup symmetric key.

    If i create a symmetric key in one of the database (say database1) by the code below:

    CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'xxxxxxxx';
    GO
    CREATE CERTIFICATE Certificate WITH SUBJECT = 'xxxxx', START_DATE = 
    '2017-05-05';
    GO
    CREATE SYMMETRIC KEY SymmetricKey WITH ALGORITHM = AES_128 ENCRYPTION BY 
    CERTIFICATE Certificate;
    GO

    How can i migrate the key so as to decrypt data in the table copied from database1 in another database (database2) stored in another server?

    And is it possible to migrate a symmetric key with no KEYSOURCE declared?

    Thanks a lot !



    Monday, May 8, 2017 9:34 AM

All replies