Re: DDL diff utility?

On Fri, 2003-09-19 at 07:42, Steve Manes wrote:
> My company offers an ASP service for advertising companies using PG.
> For contractual reasons, each client gets its own replicated database.
> This presents a problem whenever a new feature/fix requires a DDL change
> which must be rolled out across N databases. Currently, we keep track of
> these changes via a central text file in CVS with manually entered DDL
> updates.  The problem is making sure that overworked developers actually
> log all these changes.
>
> What would be better is a DDL 'diff' utility that would look at a master
> and target database and generate the necessary ALTER statements needed
> to make the target db look like the master.
>
> Is anyone aware of such a tool for PG?  I've only found it for MSSQL.
>

Check the mailing list archives, IIRC there is a project on sourceforge
that does this. It's a little weird though, I think it was written in
tcl and required a running webserver to make connections. HTH,

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL