bigdatetime and bigtime Replication

Replication Server 15.5 supports replication of the Adaptive Server 15.5 bigdatetime and bigtime. Replicate these datatypes to replicate databases and warm standby databases by specifying the datatypes in replication definitions, function replication definitions, and subscriptions.

bigdatetime and bigtime allow Adaptive Server to store data and time data up to microsecond precision. bigdatetime corresponds to the TIMESTAMP datatype, and bigtime corresponds to the TIME datatype in Sybase IQ and Sybase SQL Anywhere.

See “Support for bigdatetime and bigtime datatypes,” in Chapter 5, “Managing RepAgent and Supporting Adaptive Server” in the Replication Server Administration Guide Volume 1 to use bigdatetime and bigtime.

Mixed-Version Information

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, create a replication definition that contains 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.

Related tasks
Enabling bigdatetime and bigtime Replication