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, you must manually synchronize encryption keys at the replicate site. ddlgen supports a special form of create encryption key for replicating the key’s value.
insert and update replicate encrypted columns in encrypted form, which safeguards replicated data while Replication Server processes it in stable queues on disk.
See the Replication Server Administration Guide for information on encryption when replicating.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
