Jambu,

I am not at all saying that using a tool like ERwin is a nonesense. On the contrary, I do not see how I could go along with my ERP database with the 1000 tables and hundreds of installations that need to be updated n times a year. I have also been a very satisfied user of ERwin in the past.

Reverse enginnering also was not the subject.

The worst loss of fonctionality is in the compare option. This option has also become useless when trying to shift from trigger based RI to DRI or the other way around. ERwin mixes everything up and you end up with a mess !

Formerly, the trigger based RI was a great time saver as it produced tens of thousands of lines of code automatically.

I am just very disappointed by the new versions of ERwin which work far less better than the "old" ones. I have sent e-mails with long explanations and examples to CA without ever receiving good answers.

My remarks into this forum are just there to express my surprise that you took ERwin as an example.

In my quest of a new tool, I came across Xcase http://www.xcase.com/ which seems to be working quite well so far. I have no idea what the company behind it looks like...

Pascal