[wellylug] database schema tools

[michael at diaspora.gen.nz]

brenda writes:
>can anyone recommend a linux tool for designing a database schema.
>something that prints a diagram, and outputs sql to create the
>database....

dia, or xfig, will do the diagramming bit.  dia might even do schema
generation, although I doubt it.  Mostly, having used "professional"
tools (ER/Win, Visio), they do a so-so job at schema generation, and a
lot of tweaking is needed afterwards.

If you don't want pretty pictures, various Perl modules (Alzabo and
DDL::Oracle spring to mind) promise to help you manage and migrate
database schemas with more ease.
    -- michael.