In addition to Adaptive Server Enterprise, Sybase replication technology supports transaction replication from the following relational database servers:
DB2 Universal Database
Informix Dynamic Server
Microsoft SQL Server
Oracle
To find out about the most current, supported versions of these data servers, refer to the documentation for the Replication Agent that supports a particular non-Sybase data server.
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 supported type of non-Sybase data server.
