Check to hide differences on constraint names

litu

Hi,

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

Thanks in advance,
Litu.

Alex B

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.

gbritton

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 B

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