Homogeneous Mapping

Replication Server supports datatype translation and mapping between data servers of the same type and version.

Default Mapping

Replication Server supports replication between data servers of the same type and version for all supported datatypes. By default, Replication Server replicates data of all datatypes captured at the primary database to the same datatype on the replicate database.

User-Defined Mapping

For replication between data servers of the same type and version, you can override the default Replication Server mapping and attempt to replicate from one datatype at the primary database to a different datatype at the replicate database by:
  • altering the published datatype for a column in the replication definition, or
  • using custom function strings
Note: Be sure you fully understand the capabilities of these customization features and your business objectives before overriding the default datatype mapping behavior.
One way to alter the published datatype is by using the map to clause in a replication definition. See Replication Server Administration Guide Volume 1 > Getting Started with Translating Datatypes > Create Column-Level Translations.