SQL Source Control - Service Broker Contracts

BenPorter

I am evaluating SQL Source Control v7.1.29.11028 but no matter what repository I use (or even none) all my service broker contracts keep appearing as edited whenever I open the Commit tab. There are no actual changes highlighted and if I commit the 'changes' they still appear straight after the commit has finished.

I have tried unlinking an re-linking but the problem still exists. Is there a workaround for this?

DanC

Hi @BenPorter

I've seen this a few times and it's a strange bug with the comparison engine which can sometimes flag there's a difference when in actual fact there is no none. What you can do as a workaround is to utilize the Filter in SQL Source Control.

So with the filter, you can use rules to exclude objects from being compared, so you can exclude all "service broker contracts"

https://documentation.red-gate.com/soc/common-tasks/exclude-objects-using-filters

I hope this helps!