Does Uploading Changes Cause Merge to not use a Dynamic Snapshot
-
Wednesday, November 28, 2012 3:20 AM
I am using merge replication in SQL 2012. As mentioned here,
http://sqlchad.com/?tag=replication-2
It suggests that reinitialising my snapshot using the 'upload first' option will not use a dynamic snapshot to do the sync.
When reinitialising without using the 'upload first' option it will use the dynamic snapshot.
Is this true, if so why is this? Is there a workaround?
All Replies
-
Wednesday, November 28, 2012 4:03 AMModeratorBetter talk with SQLChad about that one.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Wednesday, November 28, 2012 4:21 PM
This was an observation I observed when working with a customer tyrying to reduce the time to re-init. As I mentioned in the article, there is no documentation around this that I could find in BOL.
To answer your question, in what I saw this is true behavior. I am planning on opening a connect item on this to see what MS comes back with, hopefully it will be a good explanation. My belief as to why it does this when @upload_first=true is it has to go through the normal enumeration process in order the get the records from the subscriber uploaded to the publisher.
There is currently not a work around that I am aware of but will keep you posted when I hear back from MS
Chad
Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz- Edited by Chad Churchwell Wednesday, November 28, 2012 4:21 PM spelling
- Marked As Answer by pmccly Friday, November 30, 2012 7:47 AM
- Unmarked As Answer by pmccly Tuesday, December 04, 2012 12:19 AM
- Proposed As Answer by Brandon WilliamsMicrosoft Community Contributor, Moderator Sunday, December 16, 2012 5:17 AM
- Marked As Answer by Brandon WilliamsMicrosoft Community Contributor, Moderator Monday, December 31, 2012 1:41 AM
-
Wednesday, November 28, 2012 4:30 PM
I have created a connect item for this at https://connect.microsoft.com/SQLServer/feedback/details/772533/dynamic-snapshots-with-merge-replication-not-being-used-with-upload-first-true
Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz- Marked As Answer by pmccly Friday, November 30, 2012 7:47 AM
- Unmarked As Answer by pmccly Tuesday, December 04, 2012 12:19 AM
- Proposed As Answer by Brandon WilliamsMicrosoft Community Contributor, Moderator Sunday, December 16, 2012 5:17 AM
- Marked As Answer by Brandon WilliamsMicrosoft Community Contributor, Moderator Monday, December 31, 2012 1:41 AM
-
Tuesday, December 04, 2012 12:26 AM
I was wondering how to get around a specific situation. If we add a filtered table to our publication we are going to be forced to update the schema snapshot, and thus in turn will make the data snapshots need to be refreshed when each user next syncs.
If we have the option to 'upload changes' then this situation will be even worse. We will have a lot of users all updating their data snapshots at a similar time over the period of a day or couple of days, and none of them will be using bulk insert.
Any ideas? Can we for instance sync once to upload changes and then sync again to reinitialise after that, or upload their changes a different way?
This discovery is a worry, and is not a good aspect of merge replication at all.- Edited by pmccly Tuesday, December 04, 2012 3:29 AM
-
Friday, December 07, 2012 5:12 PM
I currently do not have a work around for this, with that said, just adding tables to your publication will force a new snapshot, only the new table will need to be applied to your subscribers, so existing articles should be fine and not included when applying the snapshot to the subscriber during the sync process. If you add, drop, or change a parameterized filter, pending changes at the Subscriber cannot be uploaded to the Publisher during reinitialization. If you want to upload pending changes, synchronize all subscriptions before changing the filter. Please see http://msdn.microsoft.com/en-us/library/ms152745.aspx for what causes re-initializations, under Merge there is a section about adding, dropping a filter.
Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz- Proposed As Answer by Brandon WilliamsMicrosoft Community Contributor, Moderator Sunday, December 16, 2012 5:17 AM
- Marked As Answer by Brandon WilliamsMicrosoft Community Contributor, Moderator Monday, December 31, 2012 1:41 AM
.png)
