Re: ER Studio vs. Erwin vs. Oracle designer.

I went though this same process about a year ago. We went with Embarcadero because of its price and ease of use. Designer is a full lifecycle tool and is a bit
complex when you just want to generate ER diagrams and reverse engineer existing schemas. If I were still consulting I would go with Designer, but as a DBA in a fast paced Internet environment I picked ER/Studio.

As for ERwin. I had trouble with it on a project and have never looked back. It died every time I tried to reverse engineer a schema with over 200 objects in it. It is still the defacto standard in ER tools, though. If you are going to be sharing your design with many different organizations, go with ERwin. Everyone has it.

Hope this helps.

Christopher

<vdolt_at_my-deja.com> wrote in message news:8popad$idg$1_at_nnrp1.deja.com...
> I am trying to buy data modeling and database design tool.
> Has anyone has any suggestions to what is better tool from these 3 to
> use? I've got a quote from Embarcadero - 3 grand for Oracle suite (DB
> Artisan, Rapid SQL and ER studio) I don't really neeed all of them but
> they won't sell it separately. How is Oracle designer? Is there a way
> to reverse engineer existing models?
>
> P.S. We have only Oracle databases, so cross-platform capabilities are
> really irrelevant.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 13 2000 - 18:48:19 CDT