Replicating encrypted data

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

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.