Horizontal Filtering
in [Replication]
|
From: Joseph on 12 Apr 2010 16:40 This should be easy! I'm setting up transactional replication. Say that I set up a horizontal filter such as: mytable.CurrentInfo=1. After the snapshot's been applied, and everyone's happy, the following happens at the publisher: For a given replication row, mytable.CurrentInfo is updated from 1 to 0 A new row is inserted into the table, with mytable.CurrentInfo = 1. The second item's not hard: I would expect it to meet the criteria, and make its way down to my subscriber. However, the first item has me puzzled. Does it get deleted from the subscriber now that it is zero, or does it languish there? Thanks! -Joseph
From: Joseph on 13 Apr 2010 10:08 For future reference, I tested this out myself before anyone was able to respond here... The original row (the one that went from CurrentInfo=1 to CurrentInfo=0) is removed from the subscriber's database, and the new row takes its place. Just what I wanted! This forum's activity has really dropped off over the last two years....Where did everybody go? -J On Apr 12, 3:40 pm, Joseph <josephshepp...(a)gmail.com> wrote: > This should be easy! > > I'm setting up transactional replication. Say that I set up a > horizontal filter such as: mytable.CurrentInfo=1. After the > snapshot's been applied, and everyone's happy, the following happens > at the publisher: > > For a given replication row, mytable.CurrentInfo is updated from 1 to > 0 > A new row is inserted into the table, with mytable.CurrentInfo = 1. > > The second item's not hard: I would expect it to meet the criteria, > and make its way down to my subscriber. > > However, the first item has me puzzled. Does it get deleted from the > subscriber now that it is zero, or does it languish there? > > Thanks! > > -Joseph
From: Paul Ibison on 19 Apr 2010 15:07 Thanks for posting the update Joseph. As an additional note, to do the same in merge would also cause all the child records to be reparented, which can be tremendously useful. To answer your other question, I think more people use the forums now than the newsgroups. Even so, the overall presence is far lower than it used to be - I suppose blogs and websites have largely taken over. Many questions have been answered and Googling the answer is now quicker than posting a question! Cheers, Paul
From: Joseph on 19 Apr 2010 16:46 Thanks, Paul...You are the Master! -Joseph On Apr 19, 2:07 pm, "Paul Ibison" <Paul.Ibi...(a)ReplicationAnswers.Com. (donotspam)> wrote: > Thanks for posting the update Joseph. As an additional note, to do the same > in merge would also cause all the child records to be reparented, which can > be tremendously useful. > > To answer your other question, I think more people use the forums now than > the newsgroups. Even so, the overall presence is far lower than it used to > be - I suppose blogs and websites have largely taken over. Many questions > have been answered and Googling the answer is now quicker than posting a > question! > > Cheers, > Paul
|
Pages: 1 Prev: Issues with Websynchronisation Next: Dropping Indexes on Publisher Database |