Heterogeneous Replication System

A heterogeneous Sybase replication system consists of data-changing operations between two databases of the same or different vendors (except ASE to ASE).

For information on ASE to ASE replication, see the Replication Server Administration Guide Volume 1 and Volume 2.

Heterogeneous replication includes:

A replication system in which Adaptive Server Enterprise (ASE) is either the primary or the replicate data server, and a non-ASE data server (such as IBM DB2 UDB) is the other data server.
A replication system in which the primary and replicate data servers are both non-ASE data servers (for example, Oracle is the primary data server and IBM DB2 UDB is the replicate data server, or Microsoft SQL Server is the primary server and Microsoft SQL Server is the replicate server).

ASE was enhanced to support Replication Server. All of the data server elements required to support Replication Server (that is, a data-change capture mechanism in the primary database, and system tables and stored procedures in the replicate database) are either built into Adaptive Server Enterprise or enabled by utilities that are provided with the Replication Server or Adaptive Server software.

Additional components are required to implement a Sybase replication system with non-ASE data servers:

A Replication Agent
Enterprise Connect™ Data Access (ECDA) or a data server for which connectivity requirements are compatible with Replication Server, or ExpressConnect for Oracle.

Sybase Replication System with Non-ASE Data Servers diagram illustrates a typical Sybase replication system with non-ASE data servers, showing the flow of data between the data servers, through:

Replication Agent, Replication Server, and Enterprise Connect Data Access database gateway, and,
Replication Agent, Replication Server, and ExpressConnect for Oracle.

Sybase Replication System with Non-ASE Data Servers
This graphic illustrates a typical Sybase replication system with non-ASE data servers, showing the flow of data between the data servers, through Replication Agent, Replication Server, and Enterprise Connect Data Access database gateway, as well as through, Replication Agent, Replication Server, and ExpressConnect for Oracle.

This graphic illustrates a typical Sybase replication system with non-ASE data servers, showing the flow of data between the data servers, through Replication Agent, Replication Server, and Enterprise Connect Data Access database gateway, as well as through, Replication Agent, Replication Server, and ExpressConnect for Oracle.

If you are using ECDA database gateways, data flows from the primary database to the Replication Agent, from the Replication Agent to the Replication Server, from the Replication Server to the ECDA database gateway, and then from the database gateway to the replicate database.

ECDA database gateways support IBM DB2 UDB, Microsoft SQL Server, and Oracle data servers by providing connectivity between Sybase Open Client and Open Server and either ODBC or the native protocol of the replicate data server, and by providing SQL transformation and other services. Replication Server also includes datatype support for non-ASE data servers.

If you are using ExpressConnect for Oracle, data flows from the primary database to the Replication Agent, from the Replication Agent to the Replication Server, and then from the Replication Server directly to the replicate database.

Replication Agents support non-ASE primary data servers by reading the completed transactions in the primary database and sending them to Replication Server for distribution.