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

David Ng wrote:
>
> Nathan Secrist wrote:
> >
> > Database Designers/DBAs:
> >
> > We are in the process of evaluating ER/Win and Designer/2000 for
> > our Case Tool/Data Modeling Tool.
> >
> > We will be using the software for the following tasks:
> >
> > Entity-Relationship Diagrams
> > Logical Modeling
> > Physical Modeling
> > Maintaining a Data Repository
> > Automatically generate Oracle DDL from the Repository
> > Reverse Re-Engineer Oracle Tables back into the repository
> >
> > If anyone can give me some feedback on whether or not you have
> > used 1 or both of these tools.
> >
> > Let me know your experience (good or bad) with each of these tools.
> >
> > If there is other software we should look at please let me know this
> > as well.
> >
> > Thanks in advance!
> >
> >
> > Nathan
> >
> > Nathan G. Secrist
> > Evolving Systems Inc.
> > nsecrist_at_evolving.com
>
> I was a System Architect. Being a database designer, I prefer ER/Win
> a lot for it easy of use and bi-directional synchronization between
> database schema and the repository. On the other hand, I like Desginer
> 2000 for covering the whole cycle of the development, analysis,
> desginer, development etc..
>
> If you are database designer and working on a small project, ER/Win
> should be you choice. If you are project manager or working on a large
> application development, Desginer 2000 should be your choice.
>
> David Ng
From what I've seen of Erwin's Oracle schema generator, I was not [Quoted] [Quoted] impressed. Perhaps it was due to cockpit trouble on the part of the designer. (sorry, modeler...)

[Quoted] [Quoted] Instead of generating declarative referential integrity constraints when [Quoted] foreign keys are specified, the thing create a trigger for every foreign key. This is not desirable in Oracle, and in earlier releases, there was a limit on the number and type of triggers that can be placed on one table. Also, on earlier releases, triggers were run-time interpreted and this would have created unnecessary performance hits. Received on Mon Apr 07 1997 - 00:00:00 CEST