[ILUG] MySQL, dia, and ER diagrams

[Mel]

On Fri, 6 Apr 2001, Niall O Broin wrote:

> I know I'm clutching at straws here, but has anyone ever come across a tool
> which will take a MySQL (or any other RDB) schema and generate ER diagrams
> from it. I know there are tools which work in reverse i.e. generate schema
> from ER diagrams, although I don't have any.
>

I haven't heard of any but I don't think it would be possible as such. The
relations between tables might not be apparent unless the names match
exactly.  intKey in one table might match intID in another. Or worse
again, intKey in one table might have no connection at all to intKey on
another. I don't see how you could make an ER diagram without knowing
exactly what the database is

If I'm wrong, don't shoot me!

> I've been playing with dia which has an ER object set and it doesn't look
> like it would be a huge job to automatically generate at least a first cut
> at a dia diagram from a schema. Salvation for a lazy documentor, anyone ?
>

It's not too hard to generate database tables from an ER diagram but the
other way around ....... I doubt you will find a tool, but if you do, I'd
love to see it :-)

-- 
		Mel

The Final Solution: grep -vi mel life > sanity