What are the challenges you face when working across database platforms? Take the survey

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.

Best Answer


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

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
  • Options
    J LJ L Posts: 5 Bronze 1
    edited December 28, 2018 3:32PM
    I have tried, but unfortunately replication constraints are not flagged as system named:
    <div>SELECT * FROM sys.check_constraints</div>

    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.....
Sign In or Register to comment.