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. ddlgen supports a special form of create encryption key for replicating the key’s value. See “ddlgen utility extensions for encrypted columns”.
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.
Replication Server release 12.6 ESD # 5 and later supports encrypted columns.
See the Replication Server Administration Guide for information on using encryption during replication.
