Replication Server support for encrypted columns

Replication Server supports replication of encrypted column data between Adaptive Server databases. However, replication of encrypted column data to any non-ASE replicate database is not supported.To replicate non-encrypted data to an ASE database containing an encrypted column, disable the rs_set_ciphertext function string for the Adaptive Server connection.

Function string

rs_set_ciphertext

Description

Controls replication of encrypted columns to an Adaptive Server table.

Example

Alter function string rs_set_ciphertext to turn off execution of the ASE-specific command “set ciphertext on.”

alter function string rs_set_ciphertext 
for some_function_string_class 
output language
''