Compatibility between Adaptive Server and Replication Server

[CR #433315] If you are using the encrypted columns feature in Adaptive Server version 12.5.4 you must use Replication Server 12.6 (ESD#5 or later).

There is an incompatibility between Adaptive Server 12.5.4 and RepServer 15.0 when replicating an alter table statement that modifies an encrypted column to change the key. The type of the encrypted column in the replicate database will be changed to varbinary.

To correct this problem:

  1. Log in as the table owner to the replicate database; DDL replication must be enabled.

  2. Use alter table to modify the type of the encrypted column to its type at the primary site.

    For example: