How to ignore constraint names when synchronising
Ian Gordon
Posts: 3 Bronze 1
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
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
I hope that makes sense.
Cheers, Ian