Check to hide differences on constraint names

litulitu Posts: 4
edited March 2, 2017 3:46PM in SQL Compare 11
Hi,

Is there a way to hide the differences produced by the constraint's automatic naming?

Thanks in advance,
Litu.

Comments

  • Hi Litu,

    There is an option to Ignore Constraint and index names. When you are editing the compare project you can find this on the Options tab (the last tab) under Ignore (it is the fourth option down).

    I hope this helps. Let me know if you need any further assistance.
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
  • gbrittongbritton Posts: 15 Bronze 1
    Yeah the option is there but doesn't work.

    I enabled option, ran compare and got:

    [RenewRatio] [numeric] (13, 5) NULL CONSTRAINT [DF__CACommits__Renew__6287E118] DEFAULT ((0)), => [RenewRatio] [numeric] (13, 5) NULL CONSTRAINT [DF__CACommits__Renew__2EE779F7] DEFAULT ((0)),

    The only difference is the constraint name, for which I set the option to ignore the differences
  • Alex BAlex B Posts: 575 Rose Gold 4
    Hi gbritton,

    Is that a system named constraint (just guessing by how it looks)? If that is the case you may need to use the "Ignore system named constraints and index names" option, which now looking back is what I think I meant in my first reply.

    If that also doesn't work please let us know what version of SQL Compare you are on.

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.