Saturday, February 11, 2012

@force_reinit_subscription

Hi,

If I add or remove a merge article from a publication and I specify the @.force_reinit_subscription = 1, will this force a new snapshot to be sent to all subscribers? If it does, will it apply the who snapshot as it did when the subscription was created or is it clever enough to work out what bits are different?

Thanks for your help

Graham

if you drop an article, and you force reinit and snapshot generation, depending on exactly what needs to be generated, you may be required to create a new snapshot (and dynamic snapshot), and apply new snapshot. i.e. if you drop a static article (not filtered, nor not participating in any joins), you may not need to generate a snapshot. But if you the article is a filtered article, or participates in a join, the snapshot may need to be reapplied.

So yes, it's clever :)

No comments:

Post a Comment