Hide constraint names in comparison results
heck4
Posts: 5 New member
Similar to this question:
I am using the option for "Ignore system named constraints and index names" and when finding objects with differences it is ignoring these constraints.
However, if the objects have another difference unrelated to constraints, the constraint name differences are still shown in the comparison window. This is a really bad visual and hard to compare because there's a lot useless information.
In general is there a way to make the comparison view respect the comparison logic?
Option is on:
An object that is different:
Difference caused by nullablity, not constraints. Option is working.
Option doesn't affect the comparison view. Constraint differences are visible with no way to hide it. Very hard when doing a review to focus on what actually changed. The Summary View helps with this, but the SQL View remains confusing.
Tagged:
Answers
Thanks for your feedback. Unfortunately this is not possible for Compare at the moment. I'll run this past the dev team and let you know if there is any plan to improve it in the near future.
Tianjiao Li | Redgate Software
Have you visited our Help Center?
I'm afraid we don't have any current plans to attempt to convey this information via the SQL View and the Summary View was our attempt to improve this area. Can you kindly post your suggestion on our user voice forum?
Tianjiao Li | Redgate Software
Have you visited our Help Center?