Re: XML Schema for PostgreSQL database

Edson Richter wrote on 14.12.2012 00:52:
> I was wondering to create a tool for diagramming and database forward engineering.
>
> There are already few tools around.
>
> If you know a good diagramming tool able to database diff and forward engineering (with "ALTER ...", not "DROP and CREATE"), I would like to know (by today I do use one commercial tool that is feature incomplete: DbWrench).
>
> Among others, I've considered also:
> - Sybase PowerDesigner: too expensive, does not support PostgreSQL 9.1/9.2, so is not appropriate.
> - ERWin: too expensive, and doesn't have proper support for PostgreSQL 9.1/9.2.
> - NaviCat: is feature extensive, but they don't have real change scripts (are drop/create).
> - ModelRight: it's "change script" is not change at all (is just another drop/create tool).
> - TORA and other open source tools are really incomplete.
> - TOAD is too confuse for simple day-by-day work.
>

Do you mean TOAD the "SQL Tool" or TOAD Data Modeler (TDM)? TDM is far from perfect but quite nice actually.

You might also want to look at DbSchema: http://www.dbschema.com/

Thomas