How can we help you today? How can we help you today?

How to ignore constraint names when synchronising

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
Ian Gordon
0

Comments

2 comments

Sort by
  • 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.
    chriskelly
    0
  • 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 ;)
    Ian Gordon
    0

Add comment

Please sign in to leave a comment.