Re: Recommended tools for drawing E/R diagrams

I agree with this mail - Oracle Designer definitely, in fact the later the version the better as they have ironed out some of the bugs and made the tools a lot more friendly. One thing to bear in mind when naming the relationships between entities in Designer - is that when you generate the database, the foreign key columns get prefixed with the relationship name. (You'll know what I mean when you generate a physical)

Hope this helps
Bob....
In article <80sepp$hmn$1_at_nnrp1.deja.com>, jonathan.howard_at_chelmer.co.nz wrote:
> The best tool I have found is Oracle Designer and you can download
> this
> off http:\\technet.oracle.com. It is actually a full case tool
> and
> will allow 100 percent generation and maintance of a database. It
> works best with Oracle databases but it can be used for other
> databases
> as well. To set up you need to have an Oracle database installed
> as it
> has a repository that runs on the Oracle database. it can be a
> little
> daunting to get into but it has an excellent tuturiol and online
> help.
> Perservere with this one, I promise you it can save you allot of
> time.
> You are welcome to send me an email if you wish
> unashamedly an Oracle bigot
> In article <VYsxOAuEq5xL0cJoUFvganu8AQq4_at_4ax.com>,
> Jeff Kish <jeff.kish_at_ait-mmii.com> wrote:
> > Can someone give me a recommendation for an E/R diagram drawing
> tool.
> > SQL generation would be a plus. I know about ER/Win, but its a
> bit too
> > price heavy for me right now.
> >
> > Thanks,
> >
> > Jeff Kish
> >
> >
> Sent via Deja.com http://www.deja.com/
> Before you buy.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!