Nick Jenkins wrote: <snip>
Dbdesigner4 is open source (GPL), and is available for Windows and Linux. It works on MySQL, SQLlite, Oracle, MS SQL, and ODBC databases. ( http://fabforce.net/dbdesigner4/ ) It seems fairly good to me - it has a couple of minor annoyances (e.g. you can't export to SVG, only to PNG or BMP), but probably try it first for your other projects.
I also had a play with schemaSpy ( http://schemaspy.sourceforge.net/ ), (example diagram: http://schemaspy.sourceforge.net/sample/relationships.html ), which is a Java package, but I got an error trying to run it under GCJ (rather than Sun's JVM), so in the end I just stuck with dbdesigner4.
<snip>
Hello Nick,
IIRC, the main author of dbdesigner4 is working on MySQL workbench:
http://dev.mysql.com/downloads/gui-tools/5.0.html
The GUI looks great but it was alpha quality last time I checked (some months ago). You might want to have a look at it.
cheers,