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 :-)
The Final Solution: grep -vi mel life > sanity
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!