O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required