Re: [OT] ERD and schema generation

[prev] [thread] [next] [Date index for 2005/06/08]

On 6/7/05, Bill Moseley <moseley@xxxx.xxx> wrote:
> Under Linux are there any recommended tools for schema generation and
> diagramming and examples of the process?
>=20
> I've been working on a schema that has about 40 tables so far.  I'm
> working with SQLite now, but later will use Postgresql.  I wanted to
> try and generate an ER diagram to help visualize the relationships.
> But, I'm also interested in a tool that could generate SQL for
> various databases.

You might want to keep your Schema in a format like Torque
(http://db.apache.org/torque/generator/schema-reference.html), which
is supported by AutoDia and pretty easy to import to and from.
=20
> DB Designer4 [1] seems nice, but looks specific to MySQL and seems to
> be no longer in development.  tedia2sql [2] sounds nice for generating
> the SQL, but I killed over an hour trying to figure out Dia and
> tedia2sql and didn't get anywhere. [..]
> Are there tools that you use?  Any suggestions for creating diagrams?

I would reccomend autodia (http://www.droogs.org/autodia/), it reads
from SQL or straight from the DB if provided with a DSN, but then I
wrote it. It generates Dia, Umbrello, VCG and Graphviz output and you
can use your own custom templates to generate anything you want.

It's command line based and doesn't have a pretty UI, but it is bloody
useful, and I should have a very nice new release out this week with a
big bunch of improvements to SQL/DSN handling in particular.

Cheers,

A.