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, ...
Get Guru's Guide to SQL Server Architecture and Internals, The 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.
