I am having some trouble with powerdesigner 8 and Sybase 12.5. Our
database makes extensive use of columns with domain types but does not
contain any direct check constraints on these columns. When I reverse
engineer the database into a PDM and then try to generate a SQL script
with 'Modify database' the output SQL correctly sets the columns to
our custom types. However, it also adds the domain rules in to the
column as check constraints!! This is preventing us from being able to
use the tool to modify our database.
The 'Generate database' option allows me to deselect check
constraints.. Is there no way to disable check constraint generation
in 'Modify database'?
Regards,
Damon.