Ever tried Druid?
http://druid.sourceforge.net/
Il Thursday 25 October 2007 18:02:51 Tino Wildenhain ha scritto:
> Hi,
>
> Roberts, Jon schrieb:
> > I could use psql instead of pgAdmin then which isn't what I want.
> >
> > Having used Quest software SQL Navigator since 97 for Oracle and then
> > migrated to Toad for Oracle which both products have integration to
> > source control, it is hard to revert back to a command line or text file
> > solution.
>
> Well you can still use gui tools and just let them work against a
> development database. With little scripting you can just dump
> the schema of that database periodically and check it in to SVN.
>
> Hook scripts can then take over the deployment (ideally based
> on tag creation)
>
> > pgAdmin should graphically show differences between the committed version
> > and the database.
>
> Does SQL Nav do this? At least the SQL Navigator/Toad support seems
> to heavily depend on server side code to help. This looks very unclean
> to the very least.
>
> > It should allow me to click a button in the tool and commit it to the
> > repository.
> >
> > It should allow me to revert back to a previous version and the tool take
> > care of restoring the function automatically.
>
> You can test before you commit in the database - unlike Oracle, Postgres
> supports transactions even for DDL :-) (ok, I've yet find the button
> in pgadmin to disable auto commit :-)
>
>
> Regards
> Tino
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
