Snapshot Replication with immediate updating

  • Hi All,

    We have Snapshot Repilication with Immediate updating configured. It is working fine. But when i create a new table and add as an artice to this , Snapshot replication is happening from Publisher to the Subscriber but immediate updating is not happending from subscriber to publisher for this newly added table ?

    Any idea how to do this ?

     


    subban

  • This was removed by the editor as SPAM

  • I'm confused ....  You want something to go from the subscriber to the publisher ??  

  • Yes, Since Immediate/queued updating is enebled, subscriber will be able to update the publisher.

    But this is not happening for the newly added article(table)

     

    please

    help


    subban

  • What data on the Publisher do you want to get updated from the Subscriber ??

    I think that if you want the subscriber to update the publisher, (updating in both directions) you need to use merge replication.  I only have experience with transactional & snapshot replication, going just from publisher to subscriber.

  • Hi Homeberw01,

    Snapshot/ Transactional replicaiton  if you enable updatable subscribers(immediate/queued) , subscriber can update the publisher ....

    Regards

    SKv

     


    subban

  • I'm sorry .... I don't quite understand ....

     

    1) Table A at the publisher gets updated normally by  "Application A".

    2) Replication pushes those updates to Table A at the subscriber.

    3) "Application B" updates Table A at the subscriber ?

    4) Snapshot/ Transactional replicaiton can update Table A back at the publisher based on the update at the subscriber ??   I thought you needed Merge replication to do that kind of thing ?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply