Components of Replication
Replication is made up of the replication data as well as the processes, or agents, that actually execute the replication functions. These components are what makes replication function so well. In this section, we will examine the various components that make up replication.
Replication Data
The replicated data is made up of collections of articles known as publications. These articles can be tables, subsets of rows, subsets of columns, or even stored procedures.
Articles
As previously discussed, an article is a table or a subset of a table that is being replicated. Subsets are created by using filters. A filter that is used to create a subset of rows is called a horizontal filter. A filter that is used to create a subset ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
