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