ASE Replicator objects are the metadata entities that define the relationships between primary and replicate databases, and the objects within those databases.
ASE Replicator objects include:
Database connections – identify a specific database on a specific data server. There are two types of database connections: primary and replicate.
Publications and subscriptions – act as containers to organize primary or replicate articles in a database. Publications organize the primary articles in a primary database; subscriptions organize the replicate articles in a replicate database.
Articles – identify the individual database objects (tables or stored procedures) involved in replication. Primary articles identify the published objects in the primary database. Replicate articles subscribe to primary articles, and identify the subscribing objects in the replicate database.
Fields – identify the objects within an article, that is, the columns in a table or the input parameters of a stored procedure. You can use fields to publish a subset of a primary object, and subscribe to a subset of a primary article.
ASE Replicator objects are stored in the Distribution Database.
Figure 1-5 illustrates the hierarchy of ASE Replicator objects.
Figure 1-5: ASE Replicator object hierarchy
A primary database connection contains publications, which in turn contain primary articles, and those in turn contain fields.
A replicate database connection contains subscriptions, which in turn contain replicate articles, and those in turn contain fields.
There is also a dependency between primary and replicate objects, as shown in Figure 1-6.
For primary objects, all dependencies are hierarchical. For replicate objects, dependencies are both hierarchical (dependent on the next-higher-level replicate object), and horizontal (dependent on the same-level primary object).