db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Al Eridani <al.erid...@gmail.com>
Subject Re: What do you use to get an ER diagram of an existing Derby database?
Date Wed, 23 Jan 2013 20:23:42 GMT
Thank you, I'll look into them.

Al

On Wed, Jan 23, 2013 at 12:17 PM, Kim Haase <camilla.haase@oracle.com> 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
>>
>

Mime
View raw message