Hi

I am having some small issues with reverse engineering of a database with the upgrade option selected.

The problem is that the process is detecting changes in constraints when there aren't any. So if I alter a constraint, reverse engineer. The alteration to the constraint is always detected as a change. The SQL it detects is correct and gets applied to the database correctly, so there is no problem with applying the upgrade scripts, but it keeps detecting the  change over and over again.

It means I'm constantly checking if I have actually changed the constraint, and that upgrade scripts keep growing (or I have to spend time checking and removing statement - which means something could easily be missed)

Hope you can help.

EDB 2.12 Build 2.

Chris,

<< The problem is that the process is detecting changes in constraints when
there aren't any. So if I alter a constraint, reverse engineer. The
alteration to the constraint is always detected as a change. The SQL it
detects is correct and gets applied to the database correctly, so there is
no problem with applying the upgrade scripts, but it keeps detecting the
change over and over again.

It means I'm constantly checking if I have actually changed the constraint,
and that upgrade scripts keep growing (or I have to spend time checking and
removing statement - which means something could easily be missed) >>

Please send me a database that exhibits the issue via email
(timyoung@elevatesoft.com) and I'll take a look.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

<< send me a database that exhibits the issue via email
(timyoung@elevatesoft.com) and I'll take a look.>>

Hi Tim, sent via email. Just FYI its a non urgent issue.

Chris,

Sorry for the long delay, but I tried your two databases and the upgrade
reverse-engineering works fine with them.  The first time it generates some
alterations for the constraints due to differences in the delete action, and
then a subsequent upgrade script generation comes up empty.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com