How to ignore constraint names when synchronising

Ian Gordon

Hi, when I compare 2 DBs with SQL Compare 8 it lists several tables as existing in both but different where the only difference is in the names of constraints, such as:
DB1:
[DateCreated] [datetime] NULL CONSTRAINT [DF_DT_MyData_DateCreated] DEFAULT (getdate()),
DB2:
[DateCreated] [datetime] NULL CONSTRAINT [DF_DT_MyData_DateCreated_1] DEFAULT (getdate()),

so is it possible to get SQL Compare to ignore these name differences and not list the tables as being different?

Thanks if you can help, Ian

chriskelly

You can use to Ignore option "Constraint and index names". However, you should be aware that if there are other differences in the object then it will still be listed as different and the names will still be highlighted, but the listing will not be based on the constraint or index names.

I hope that makes sense.

Ian Gordon

it does indeed - that's what I was looking for. Found it in Tools | Project Options (thought I'd mention that because you didn't!)

Cheers, Ian