Chapter 3: Administering ASE Replicator

Managing primary and replicate articles

Articles identify the database objects affected by replicated transactions. Primary articles identify the source of replicated transactions, which are objects in the primary database. Replicate articles subscribe to primary articles and identify the destinations of replicated transactions, which are objects in the replicate database.

Table 3-5 lists the ASE Replicator procedures you can use to manage primary and replicate articles.

**Table 3-5: ASE Replicator primary and replicate article procedures**
Procedure	Description
sp_addprimaryart	Creates a new primary article
sp_addreplicateart	Creates a new replicate article
sp_dropprimaryart	Deletes an existing primary article
sp_dropreplicateart	Deletes an existing replicate article
sp_helpprimaryart	Returns information about primary articles
sp_helppub	Returns information about publications
sp_helpreplicateart	Returns information about replicate articles
sp_helpsub	Returns information about subscriptions

View this book as PDF