A telecommunications company has satellite offices in San Francisco and Chicago that use Microsoft SQL Server to store local customer information. Headquarters in Boston uses ASE to store company-wide customer information. Replication Agent captures the changes in Microsoft SQL Server at the satellite offices and passes them to Replication Server. Replication Server applies data changes to the headquarters’ consolidated customer database, which is stored in ASE.
To set up unidirectional consolidation into a central repository, the telecommunications company uses the following components:
Sybase Replication Server
ASE
RSM
Sybase Replication Agent for Microsoft SQL Server
See Chapter 1, “Introducing Replication Server Options,” for descriptions of specific components.
Figure 2-1 illustrates this sample scenario.
Figure 2-1: Unidirectional consolidation into a central repository
