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

Is there a way to ignore Constraints as to whether objects are the same/different?

I have several hundred objects that fall into the "...in both, but different" when the only thing that is different is the 8-character code added at the end of the Constraint:

[column] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_table_pg_fi_1E3252DS]

I'd like to optionally ignore CONSTRAINT and everything to the right
JordanT
0

Comments

1 comment

Sort by
  • David Atkinson
    SQL Compare has an option that allows you to ignore system generated constraint names:
    Visit Edit project/Options and check "Ignore system named constraint and index names". 
    David Atkinson
    0

Add comment

Please sign in to leave a comment.