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

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

Active

Type:	Bug
ID:	772533
Opened:	11/28/2012 8:29:53 AM
Access Restriction:	Public

Workaround(s)

view

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

Details (expand)

English

SQL Server 2012 - Enterprise Edition

Replication

Windows Server 2008 R2 Enterprise (SP1)

US English

1. Create publication using dynamic row filtering (HOST_NAME override)
2. Create pull subscription to publication
3. Create dynamic snapshots
4. Insert data on subscriber
5. Perform re-init with upload changes from subscriber to publisher setting

1. Full enumeration happens and dynamic snapshot is not used

1. Expected subscriber to upload rows to publisher and then dymanic snapshot to be applied to subscriber

X64

0 attachments

            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