Re: Best open source tool for database design / ERDs?

tedia2sql for DIA seems pretty strange, in that it seems to require you
to use UML diagrams, rather than ER Diagrams, to forward engineer a
database - e.g. output DDL statements.

Am I misreading what tedia2sql does, or is does one have to use
repurpose UML diagrams to get DDL statements created?

I was a little disappointed with the ER Diagram functions of DIA. Looks
like you can only add a few properties at most given the way it is
structured - having circles radiating out from the Entity. There's only
so much screen space... then there's no way to specify a SQL ANSI data
type from what I recall.

Is there a commercial tool that's less than $200 which kicks the *ss of
any of these open source solutions? I'd rather use something free, but
not if it doesn't do what I want it to do easily.

I like the Open Office apps like Writer and Calc. Calc in particular
does everything Excel does - at least everything I've ever used Excel
for.

Seems like the open source data modeling tools aren't feature-rich
quite yet.

Dana