Adding a Filter to an Article
Filtering lets you send a subset of the data in a publication to each Subscriber. You can add a filter to a publication by using the Publication Wizard or the sp_addmergefilter stored procedure.
How Row and Column Filtering Works
Microsoft SQL Server replication offers row and column filtering. This lets you define and maintain subsets of data that can be published to different devices. You can use row filtering to publish a subset of rows in a published table. For example, in a service organization, each service representative might have to receive only the customer records for the accounts they service. You can use column filtering to publish a subset of columns in a published table. For example, you can use a column filter to eliminate large text or image columns that you might not want to publish to a smart device.
Note
You can use both row and column filtering on the same article within a publication.
For more information, see "Filtering Published Data" in SQL Server Books Online.
Using the Publication Wizard to Filter a Publication
When you use the Publication Wizard to create a publication, you select the articles you want to publish by selecting the check box next to each article. When you select an article, you can add filtering. Both column and row filtering are configured at the same time in the wizard.
Using sp_addmergefilter to Filter a Publication
The sp_addmergefilter stored procedure lets you filter a publication. This stored procedure has many arguments, but there is only one argument that requires a specific value when you use SQL Server Compact 3.5 subscribers:
| Argument | Description or Requirement | SQL Server version |
|---|---|---|
@filter_type |
Only '1' (join filter) is supported. |
SQL Server 2005, SQL Server 2008 |
Note
SQL Server Compact 3.5 does not support synchronizing with publications that contain logical records.
See Also
Concepts
Adding an Article to a Publication
Using Row-Level and Column-Level Tracking