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

Posted in 1997

Topics: Triggers, Constraints & Referential Integrity

Jim Russell — Tue, 08 Apr 1997 08:41:19 -0400 — source: Informix-list mailing list archive (1991-1998)

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@hoffman.army.mil) Entity: an object with no class that doesn't know how to behave.