What are the challenges you face when working across database platforms? Take the survey

Project Options - Default Constraint Names

Chris WoodcockChris Woodcock Posts: 2
edited November 13, 2009 11:45AM in SQL Compare Previous Versions
The following project option.

"Ignore constraint and index names"

Is described

"Ignores the names of indexes, foreign keys, primary keys, and default, unique, and check constraints when comparing databases. Note that the names will not be ignored when the databases are synchronized."

But if I tick this box then when a new table is added to my target which had specific default names in the source the default constraints have auto generated names in the target.

Where I am going wrong with this?

I would think from the description "not be ignored" means that it would add columns with the specific default names that the source had?


  • Options
    Thanks for your post.

    The behaviour of the option should be consistent with the definition, so I'm not sure why it's working differently with your database. It seems to work as expected when I tested it.

    Would you be able to send me the structure of the object that exhibits this behaviour and I will see if I can recreate the problem?
Sign In or Register to comment.