Replicate Encrypted Data

Replication Server supports the replication of encrypted data.

If your site replicates schema changes, the following DDL statements are replicated:

alter encryption key
create table and alter table with extensions for encryption
create encryption key
grant and revoke create encryption key
grant and revoke select on the key
grant and revoke decrypt on the column
sp_encryption system_encr_passwd
drop encryption key

The keys are replicated in encrypted form.

If your system does not replicate DDL, manually synchronize encryption keys at the replicate site. The Adaptive Server ddlgen utility supports a special form of create encryption key for replicating the key’s value. See the Adaptive Server documentation for information on the ddlgen utility.

For DML replications, the insert and update commands replicate encrypted columns in encrypted form, which safeguards replicated data while Replication Server processes it in stable queues on disk.