Mixed-version Issues

In a mixed-version environment, the route version between the primary and replicate Replication Servers determines which features are supported.

  • Only Adaptive Server versions 15.5 and later support bigdatetime and bigtime. If the primary data server is at least Adaptive Server 15.5, and:

    • Primary and replicate Replication Server are version 15.5 or later, and the replicate Adaptive Server does not support the datatypes, you can create a replication definition containing a mapping for each of the two datatypes to the varchar datatype. Alternatively, use the varchar datatype instead of the two datatypes in the replication definition.

    • Primary Replication Server is version 15.5 or later, and the replicate Replication Server and Adaptive Server do not support the datatypes, use the varchar datatype instead of the two datatypes in the replication definition.

    • Primary and replicate Replication Server, and the replicate Adaptive Server do not support the datatypes, RepAgent automatically sends the varchar datatype to Replication Server.

  • For replication of a quoted identifier to succeed, the primary Replication Server and the Replication Server that connects to the replicate data server version must be 15.2. However, intermediate Replication Servers in a route can be earlier versions.

  • A replication definition created with unitext columns is not propagated to Replication Server version 12.6 and earlier.

  • A replication definition subscribed by Replication Server version 12.6 and earlier cannot be altered to add unitext columns.

  • A replication definition created with unitext columns is propagated to Replication Server version 12.6 or earlier if the unitext columns are removed.