Top 10 SQL Compare Tips. Watch now.

My "Ignore constraint and index names" option does not work for SQL Compare

derektderekt Posts: 2 New member
I have version 13.1.6.5463. This simple does not work for me. Does anyone have a solution for this?

Thanks in advance
Tagged:

Answers

  • Hi @derekt

    It seems that you are hitting a known bug SC-9192. It was because the target has two indexes which are functionally the same, but only one of them is in the source with a different name. We think in the engine it would be a rename and therefore ignore it not accounting for the fact there is only 1 of it in the source but two in the target.

    Can you please send in an example to confirm it?

    Thanks!
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.