Options
Project Options - Default Constraint Names
Chris Woodcock
Posts: 2
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?
"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?
Comments
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?