Re: ER/Win vs Designer/2000 - Which is better?

Robert Miller wrote:
> From what I've seen of Erwin's Oracle schema generator, I was not
> impressed. Perhaps it was due to cockpit trouble on the part of the
> designer. (sorry, modeler...)
>
> Instead of generating declarative referential integrity constraints when
> foreign keys are specified, the thing create a trigger for every foreign
> key.

I've seen that same output from ER/Win, and I wonder if I'm just failing to understand it -- the thing generated bunches of triggers rather than defining constraints. I also played once with S/Designer and was underwhelmed -- When I tried to reverse engineer a DB I had set up by hand, the damn thing ignored existing trigger definitions, and replaced the constraints defined with a slew of triggers. Can someone explain the reasoning behind that??
(With ER/Win, my target db's were SQL Anywhere and Oracle 7; in S/Designer I was using just Oracle 7.)

-- 
/Jim Russell (temp alt: russelj0_at_hoffman.army.mil)
Entity: an object with no class that doesn't know how to behave.