You might look into Eclipse (the java-based IDE). It has at least one ERD
design plugin that allows graphical layout, editing of schema, and
generation of DDL directly from the schema. It works with many DB platforms
and is FREE!!!
Sean
On 6/1/06 5:44 AM, "dananrg(at)yahoo(dot)com" <dananrg(at)yahoo(dot)com> wrote:
> Anyone know if DIA will generate CREATE TABLE statements from an ER
> diagram?
>
> I'd like to have a program where I can create my db design, then be
> able to instantiate the design in PostgreSQL as well as MySQL.
>
> I'll pay for a good commercial tool if it costs less than USD $100.
>
> Thanks.
>