Post reply

Subscriber & constraints

  • July 7, 2015 at 8:32 am

    #298328

    We have transactional replication setup. I saw they created constraints & relationship in the subscriber also.

    Really do we need to have constraints on subscribers. This is one way only. Not updatable sunscribers

  • July 7, 2015 at 10:29 pm

    #1810842

    No - you don't need constraints on the subscriber. All you need are the primary keys for replication - assuming that you are not replicating stored procedure execution (you would then need indexes that support the logic of the stored procedure otherwise you risk poor performance on the subscriber).

  • July 8, 2015 at 9:38 am

    #1811014

    How to find we are executing the sp execution in subscriber db

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

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