In a heterogeneous replication system, when information is replicated from one data server to another, values stored at the primary data server must often be altered so that they can be copied successfully to a different datatype at the replicate data server. User-created function strings can produce these datatype translations, but require significant user input and are limited by the capabilities of the replicate data server.
To make datatype translations more readily available for different data servers, Replication Server provides heterogeneous datatype support (HDS), an easy-to-apply methodology for translating datatypes at the Replication Server. HDS supports selected datatype translations between these data servers:
Adaptive Server Enterprise
DB2
Oracle
Microsoft SQL Server
UDB
When you use HDS, you can choose which columns and datatypes in the primary database are to be translated, and which replicate data servers will receive the translations.
Sources of information:
See the Replication Server Heterogeneous Replication Guide.
See the Replication Server Configuration Guide for your platform for instructions for installing and setting up the objects that enables HDS.
See the Replication Server Reference Manual for descriptions of the function strings.
