SQL Server Performance

Replicate encrypted database

Discussion in 'SQL Server 2005 Replication' started by BugMe, Mar 28, 2007.

  1. BugMe New Member

    I have been doing some readings online regarding replicating encrypted database in SQL 2005. Some indicated that 2005 does not allow replication on encrypted database and some articles mentioned that there're ways around it. So, my first question is: Is it possible to replicate a encrypted database? If it is, where can I find a good article as to how to make it happen?

    Thanks

    Bugme
  2. MohammedU New Member

    You can replicate the encrypted data...
    Check the BOL topic "How to: Replicate Data in Encrypted Columns"
    Replication enables you to publish encrypted column data. To decrypt and use this data at the Subscriber, the key that was used to encrypt the data at the Publisher must also be present on the Subscriber. Replication does not provide a secure mechanism to transport encryption keys. You must manually re-create the encryption key at the Subscriber.

    http://msdn2.microsoft.com/en-us/library/bb326115.aspx
    Elements of Replication Security
    http://msdn2.microsoft.com/en-us/library/ms151228.aspx



    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. marlin New Member

    Will creating the same encryption key at the Subcriber impose any security risk to the database/server on the Publisher in any way?
    Thanks.
    marlin
  4. satya Moderator

    I don;t think so as it is required in order to continue the replication.

Share This Page