Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Merge replication - excluded columns Expand / Collapse
Author
Message
Posted Monday, February 11, 2013 3:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 9:22 PM
Points: 8, Visits: 541
I have excluded a column from replication. In post snapshot processing, I add this column back on the subscriber and update with a computed value.

Even though this column isn't replicated, the updates all go back to the publisher (I can see these in the msmerge_genhistory table on the subscriber and in the publisher). They don't actually change data on the publisher but they do go through the replication processing. This is forcing large amounts of data to go across our WAN. Is there any way for merge replication to 'ignore' the updates to this column?
Post #1418671
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse