Here are a couple of possibilities from people who've used such tools:
1) What I've used is called MySQL Workbench, freely available at
http://dev.mysql.com/downloads/workbench/ (GPL license).
First dump the sql structure from a DB using dblook
(http://db.apache.org/derby/docs/10.8/tools/ctoolsdblook.html) and then
import into workbench.
Sometimes the sql file is not perfect (specific derby syntax for
something) but it's something very easy to change during import.
2) I've also used a tool called schemacrawler to generate diagrams. The
output formats include PNG and SVG.
http://schemacrawler.sourceforge.net/
It works with a bunch of different databases, and will generate the
graphic on a live database.
The downsides are that the diagrams don't look as nice as MySQL
Workbench, and I couldn't get it to graphically show the FKs.
Hope this helps!
Kim Haase
On 01/23/13 02:19 PM, Al Eridani wrote:
Hello, we have an existing Derby database that we would like to
document with an entity relationship diagram.
I'm looking for a tool (preferably free) that will be able to generate
the diagram by inspecting the database.
I use Eclipse under Linux and I have the Data Tools Platform
Enablement Extender SDK installed; it works well to make queries,
but no diagramming.
Thank you in advance for any pointers.
Al
