Re: RFC tool to support development / operations work with slony replicated databases

Andrew Hammond wrote:
> Each release will include a directory that has the same name as the
> full release tag. This directory must contain all the scripts to be
> applied.

Have you considered using a data dictionary instead, so that you can
simply diff the structures and generate DDL to bring a database to its
current state?

If your scripts contain data modification code, they can be preserved,
but using a dictionary smooths over a lot of the quirkiness of the
scripts-based approach.


--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com / www.andromeda-project.org
Office: 631-689-7200   Cell: 631-379-0010

::Think you may have a problem with programming? Ask yourself this
::question: do you worry about how to throw away a garbage can?