Home Dashboard Directory Help

dynamic snapshots with merge replication not being used with @upload_first=true by Chad Churchwell



Sign in
to vote
Type: Bug
ID: 772533
Opened: 11/28/2012 8:29:53 AM
Access Restriction: Public
User(s) can reproduce this bug


I had a merge replication publication set up with dynamic row filtering on most of the articles. I also have defined and generated dynamic snapshots and expected those to be used during a re-init operation. What I noticed is if I choose to upload changes fropm subscriber to publisher when performing the re-init, it does not use the dynamic snapshot and performs a full enumeration. If I choose not to upload changes from subscriber to publisher it does use the dynamic snapshot and completes much faster. I would like to know if this is expected behavior and a explanation on why so I can communicate to my clients or if this is a bug of some sort
Sign in to post a comment.
Posted by Microsoft on 11/30/2012 at 8:34 AM
            Hi Chad Churchwell,
            thanks for taking the time to share your feedback, this is really important to us.
            We will investigate the issue and get back to you.
            Best regards
            Jean-Yves Devant 
            Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server
            Program Manager SQL Server Replication, Change Data Capture, Change Tracking
Sign in to post a workaround.