Merge pull subscription reinitialize based on data changes RRS feed

  • Question

  • I have merge pull subscription with parameterized filter (dynamic snapshot), I have automatically generate snapshots option enabled. However, my data changes very frequently, sometimes 100s of records in few mins.

    In such cases, I would like to determine the number of merge incremental data changes and if it exceeds a certain number(say 100 records), I want to generate a new dynamic snapshot and reinitialize the subscription.

    Please let me know which tables should I looks for to determine the merge incremental data changes that are pushed to subscriber.

    Whenever there is bulk upload(not bulk commands, huge data inserted in a short interval) to the tables, I want to create a snapshot and apply to subscribers.

    How do I find out number of changes happened after the last snapshot generation?
    • Edited by Viki Vig Monday, October 1, 2012 3:12 PM clarity
    Monday, October 1, 2012 3:03 PM