Post reply

Update a table on the Replicated(Subscriber) database

  • March 23, 2010 at 11:04 am

    #222178

    Scenario.

    Replication runs every 15 minutes.

    We are updating table on the publisher and querying that table on the subscriber.

    Therefore, the update can take up to 15 minutes to get down to the subscriber.

    My solution is to update both the publisher and subscriber, but now sure if this is should be done?

    Or is there another solution that would be better. I don't want query the live DB.

  • March 23, 2010 at 8:59 pm

    #1138678

    Why not change the distribution agent to run continuously and reduce/eliminate the need to update both databases ?

    As far as doing UPDATEs on the subscriber, this shouldn't be a problem for replication. Doing INSERTs or DELETEs may be an issue which can be dealt with if you use custom stored procs for these actions.

Viewing 2 posts - 1 through 1 (of 1 total)

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