June 1, 2006 at 7:15 am
I am trying to Transactionally replicated from Table A to Table B, and Also send the changes by transactional repl to Table C,
Now changes made at A Replicate to B, and stop the B changes are not being replicated to C.
If the change is made at B directly it replicate to C,
Can someone help me please so that Change made at A get to B and B in turn transactionally sends the changes to C
thanks
June 1, 2006 at 11:02 pm
Unfortunately your explanation is not very clear.
Tables are not "published" directly but are articles of publications.
Which is the publisher?
Presumably, you mean that the other two machines are subscribers and are not in turn re-publishing the same data?
Sorry to answer your question with more questions but I just don't understand your problem at the moment.
June 2, 2006 at 2:44 am
Tables A, B, and C are all articles of publications, B is publishing-subcriber,
B is surppose to re publishe what it received from A to C but it does not. the articles changes in A get to B and stops . the logreader agent can detect the changes at B and send it to the distributor agent which doesn't send them to C.
Changes made directly at B get published to C.
Topology:
A publisher to Subcriber B
B subcriber, Publish to C
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply