How to ignore constraint names when synchronising

Ian GordonIan Gordon Posts: 3 Bronze 1
edited July 1, 2011 10:36AM in SQL Compare Previous Versions
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

Comments

  • 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 GordonIan Gordon Posts: 3 Bronze 1
    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 ;)
Sign In or Register to comment.