Re: Design Tool?

From: Van Messner <vmessner_at_bestweb.net>
Date: Fri, 02 Mar 2001 00:54:31 GMT
Message-ID: <bbCn6.2834$Hg.222549@monger.newsread.com>

There is no ideal tool. Currently I'm using Designer 6i version 2 and it has some problems. To take advantage of all the new Oracle features I have standard scripts for object creation that deal with things like deferrable constraints, function-based indexes, bitmapped indexes, naming all constraints, etc. The scripts provide a template for new objects so not very much has to be rewritten and I don't have to memorize syntax.

If I'm not doing a project in Designer that starts at the very top with dataflows and business rules, then I just use it as a CASE tool, create the objects from scripts and reverse engineer what I've created in Designer for the diagrams.

The scripts are completely portable and this system seems to work as well as any other.

Van

"anon" <anon_at_anon.com> wrote in message
news:bJBn6.163350$v.14271114_at_typhoon.nyroc.rr.com...
> My DBA shop is currently using Designer 6.0 for DB design. It's too slow
and
> buggy and we are starting to look at other tools. I did an eval of Erwin
> which is very fast, but it doesn't support functions or any of the newer
> features like Function-Based-Indexes. Even the new release of Erwin, 4.0,
is
> not going to support these features.
>
> Can anyone recommend a tool that is easy to use for basic database design
and
> reverse engineering?
>
> Thanks!
>
Received on Thu Mar 01 2001 - 18:54:31 CST