Post reply

Constraints and FKs

  • September 13, 2005 at 7:50 am

    #94889

    Hi All,

    I would like to changed all Fks and Constraints to NOT FOR REPLICATION on a number of tables that are all currently part of merge replication.

    Has anyone had experience of this?

    Do I need to DROP the replication to apply the changes?

    Is there anything I should be aware of ?

    Thanks a lot

    Graeme

  • September 13, 2005 at 5:32 pm

    #589545

    It would be better if you removed Replication and then set the NOT FOR REPLICATION on the desired Tables. Once that is done, Then set up Replication again.

    Kindest Regards,

  • September 14, 2005 at 2:10 am

    #589622

    Thanks for that Trigger,

    I had a feeling that was going to be the answer. My issue was FK records were being replicated before the PK record and so were conflicting. Having done a bit of research, one solution was to change constraints to NFR, another was to increase the batch size in the profile. I have tried increasing the batch size and will see if I still need to apply the changes to the constraints.

    Thanks Again...Graeme

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

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