These components are required to implement a Sybase replication system for Microsoft SQL Server:
A primary Microsoft SQL Server database
A replicate Microsoft SQL Server database
A Replication Server
The Replication Server Options components:
Replication Agent
ECDA Option for ODBC
Figure 1-1 illustrates a Sybase replication system with Microsoft SQL Server databases. It shows the flow of data between the databases and the Replication Agent, Replication Server, and ECDA database gateway.
Figure 1-1: Sybase replication system for Microsoft SQL Server