Re: DDL diff utility? - Mailing list pgsql-general

From Robert Treat
Subject Re: DDL diff utility?
Date
Msg-id 1063981246.30308.1673.camel@camel
Whole thread Raw
In response to DDL diff utility?  (Steve Manes <smanes@magpie.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Access Ingres database
Next
From: Tom Lane
Date:
Subject: Re: Why does adding SUM and GROUP BY destroy performance?