Understanding replication concepts  Stored procedure replication

Chapter 1: Introduction to ASE Replicator

Table replication

Replicated transactions are published by table. When data-changing operations affect the contents of a published table in the primary database, they are recorded for subsequent distribution to a replicate database.

A replicate database can be a subset of a primary database, with some, but not all of the tables in the primary database. Therefore, not all of the tables in a primary database have to be published.

To receive replicated transactions, the replicate database must subscribe to a published table in the primary database, and it must identify the subscribing replicate database table. Replicated transactions from the primary database are distributed to subscribing tables in the replicate database.





Copyright © 2004. Sybase Inc. All rights reserved. Stored procedure replication

View this book as PDF