There are several issues related to non-Sybase primary data servers in a Sybase replication system. A successful replication system must address all of the issues for each primary data server.
Non-Sybase primary data server issues include:
The requirements of the Replication Agent, including any limitations, intrusions, and impacts on the data server’s operation
The access and permissions necessary for the Replication Agent to obtain transactions from the primary database
The connectivity requirements to support communications between the primary data server and other replication system components
The limitations imposed on the replication system by the non-Sybase data server
The datatype conversions (or translations) that may be required to replicate transactions from one type of data server to another
The replication system management issues specific to the non-Sybase data server
The following sections describe the specific primary data server issues for each actively supported type of non-Sybase data server.