Dynamic Filter--Join Filter
Computer Name: queen
Database: EComm --Publisher
Table structure
Data inside three tables:
Create a Merge publication (JoinCondition) with the following join filter:
Computer Name: queen
Database: EComm --Publisher
Table structure
Data inside three tables:
Create a Merge publication (JoinCondition) with the following join filter:
Database: subData
Create a subscription to the publication (JoinCondition) with the Merge Agent security: QUEEN\Administrator
As shown below, only related data is pushed to the subscriber.
