Domain constraint not being generated
Hello,
I have a case where a logical model was reverse engineered from a database, along with the constraints. Now domains have been created to represent those constraints and the columns on the entities have been updated to reflect these domains, and the reverse engineered check constraint removed.
The problem now is that when I generate a relational model, the column check constraints are not always generated. even though the "use domain constraints" flag is checked on the relevant attributes. On the relational model the flag is also checked, but the DDL preview, and the generated DDL script do not reflect the column check constraint.
In some cases, it appeared to be because the attribute also had a check constraint name the presence of which appeared to override the "use domain constraints" flag. In some cases, removing the reverse engineered constraint name and regenerating the relational model solved the problem, but in other instances the column check constraint is simply not generated when the DDL is previewed, even though everything appears ok on both the logical and relational models.
Has anyone experienced this before, and is there a solution?
Thank you
Femi
Edited by: fakintoye on Feb 9, 2012 5:30 PM
I started the process with DM 3.0 665, but even with DM 3.1 700 the same thing happens