Thank you, I'll look into them. Al
On Wed, Jan 23, 2013 at 12:17 PM, Kim Haase <[email protected]> wrote: > 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 >> >
