New opaque Datatype

The opaque datatype handles replication of datatypes that Replication Server does not support.

RepAgent provides formatting data that can be directly applied in the target database. The opaque datatype handles replication of datatypes that can store unspecified or inconsistent values, such as anydata datatype and the Microsoft SQL Server sql_variant datatype.

Limitations

Limitations of the opaque datatypes include:
  • You cannot use opaque datatypes in searchable columns and where clauses of replication definitions, subscriptions, and articles.

  • You cannot use a map to clause with opaque datatypes.

  • You cannot use dynamic SQL when an opaque datatype column or parameter exists in your replication definition.

  • You cannot use the opaque datatype if your function string has a remote procedure call (RPC).

  • You cannot apply character set conversion or byte-order conversion to opaque datatypes.

In a mixed-version environment, the primary and replicate Replication Server must have a site version of 15.1 and an LTL version of 710.

For more information about opaque datatypes, see the Replication Server Reference Manual.