Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
Add, drop, or change a row filter

Answered Add, drop, or change a row filter

  • Donnerstag, 14. Februar 2013 21:58
     
     
    Anmelden
    0
    If you need to modify a row filter documentation on msdn says that pending changes at the subscriber cannot be uploaded to the publisher during reinit.  It sounds like the only true solution is to have everyone synchronize their changes first before modifying the row filter, but what if this isn't possible?  What if there are thousands of subscribers and coordinating this won't be possible.  Are there any other options?  Or will those who didn't synchronize prior to the row filter change just lose their unsynced data?
     

Alle Antworten

  • Montag, 18. Februar 2013 05:51
    Moderator
     
     
    Anmelden
    0

    Hi nighttrain79，

    Are you using snapshot or transactional publication? If so, I think it is necessary to synchronize the changes first before modifying the row filter. After modifying the filter, we need to rerun the Snapshot Agent job for the publication to generate an updated snapshot and reinitialize subscriptions. For more detail information, please refer to the following link:

    How to: Define and Modify a Static Row Filter (Replication Transact-SQL Programming)
    http://msdn.microsoft.com/en-us/library/ms147287(v=sql.105).aspx

    TechNet Subscriber Support
    If you are     TechNet Subscriptionuser and have any feedback on our support quality, please send your feedbackhere.

    Allen Li
    TechNet Community Support

     
  • Montag, 18. Februar 2013 15:26
     
     
    Anmelden
    0

    We are using merge replication.  We have a large user base and will be very difficult to schedule every user to synchronize prior to modifying the row filter, which will require reinitialization and a new snapshot.  I'm just wondering if there are any other options.  I feel like there will be several users who will end up having unsynchronized changes and will end up losing their data.

     
  • Mittwoch, 20. Februar 2013 06:35
    Moderator
     
     Beantwortet
    Anmelden
    0

    Hi, as you said,

    I feel like there will be several users who will end up having unsynchronized changes and will end up losing their data.

    If we modify the filter without reinitializing the subscribers, some data changes will be lost. The following document lists all properties that require our actions if they are changed, you can refer to it:

    Change Publication and Article Properties
    http://msdn.microsoft.com/en-us/library/ms152745.aspx

    Allen Li
    TechNet Community Support

     
  • Mittwoch, 20. Februar 2013 15:14
    Moderator
     
     Beantwortet
    Anmelden
    0

    NightTrain, when I have had to do things like this, I query MSmerge_genhistory and msmerge_contents and msmerge_tombstone to get a list of rows which have changes on the subscriber and need to go to the publisher.

    You can also use sp_showpendingchanges for this.

    Then I bcp these rows out into the file system and upload them to the publisher via ftp. Most of this can be done via xp_cmdshell, but then you have to be able to coordinate your subscribers being online when you do this.

    I have also sometimes done backups on the subscribers, uploaded them to the publisher (against using ftp) and run comparison queries to figure out what should go into the publisher. All of this takes considerable effort when you are dealing with 100's of subscribers.  Of course if you are using sqlce it gets even harder.

    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