O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

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

Filtering

As with other types of replication, you can filter merge replication vertically as well as horizontally. Horizontal (or row) filters are implemented via an SQL WHERE clause and limit the rows a publication includes based on user-specified criteria. Vertical (or column) filters limit the columns that a publication includes.

When you define a column filter, a view is created that includes only the requested columns. This view will have a name of the form publication_ article_VIEW and will reside in the publication database. The object ID of this view, rather than that of the base object, will be stored in the sysmergearticles sync_objid column and will be queried for new rows by the Merge Agent.

On the subscriber side of the equation, ...

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