SQL Source Control - Merge Replication generating changes

We use merge replication across multiple sites, and it generates, manages and enforces key constraints across all of our tables.

SQL source control is seeing these changes and flagging them up, however, whilst this is *technically* correct, this is causing a lot of false positives and we are losing track of *actual* changes in a sea of replication, effectively rendering the product useless.

Is there any way to tell SQL source control to ignore system (replication) generated key constraints? Even if I have to manually select each constraint to ignore (there are hundreds), the one off cost of doing so would be well worth it.


  • Have you tried to ignore "System named constraint and index names"? To do it, please go to Set up->Comparison Options.
    Tianjiao Li

    Product support team
    Redgate Software
  • J LJ L Posts: 4 New member
    edited December 28, 2018 3:32PM
    I have tried, but unfortunately replication constraints are not flagged as system named:
    SELECT * FROM sys.check_constraints

    They are, however, all named in a consistent way, for example:
    Shouldn't be difficult for the devs to add an option to ignore replication constraints.....
  • I've found a similar suggestion on our user voice forum. Can you kindly vote for it?
    Tianjiao Li

    Product support team
    Redgate Software
Sign In or Register to comment.