Replication Server

Replication Server can access data locally instead of from remote, centralized databases. Compared to a centralized data system, a replication system improves system performance and data availability, and reduces communication overhead.

Replication Server provides a cost-effective, fault-tolerant system for replicating data. Because Replication Server replicates transactions—incremental changes instead of data copies—and stored procedure invocations, rather than the operations that result from execution of the stored procedures, it enables a high-performance distributed data environment while maintaining transactional integrity of replicated data across the system.

• How Replication Server Works
  Replication Server distributes data over a network by managing replicated transactions while retaining transaction integrity across the network.
• Publish-and-subscribe Model
  Data are published at the primary sites to which Replication Servers at other (replicate sites) subscribe.
• Replicated Functions
  Performance can be improved over normal data replication by encapsulating many changes in a single replicated function.
• Transaction Management
  Replication Server depends on data servers to provide transaction-processing services. To guarantee the integrity of distributed data, data servers must comply with transaction-processing conventions, such as atomicity and consistency.
• Relationship with Other System Components
  Replication Server interacts with other components of a replication system as either a server or a client.
• Database Connections
  Replication Server keeps track of other components in a replication system using connections that identify primary and replicate databases and routes that identify other Replication Servers.
• DDL User Purpose
  Replication for Microsoft SQL Server and Oracle can replicate DDL commands that are entered at the primary database to the subscribers database.
• Datatypes, Datatype Definitions, and Restricted Datatypes
  Datatype definitions for a particular data server datatype are grouped in a datatype class.
• Error and Function-string Classes for Non-ASE Data Servers
  Sybase provides function-string classes and associated function strings for all supported non-ASE replicate data servers.
• Object Publication and Subscriptions Limitations
  Learn about the limitations to object publications and subscriptions in a Sybase replication system.