Is there a way to ignore Constraints as to whether objects are the same/different?
JordanT
Posts: 1 Bronze 1
in SQL Compare
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
[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
Tagged:
Answers
Visit Edit project/Options and check "Ignore system named constraint and index names".
Product Manager
Redgate Software