From: | Steve Manes <smanes(at)magpie(dot)com> |
---|---|
To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | DDL diff utility? |
Date: | 2003-09-19 11:42:34 |
Message-ID: | 3F6AEBAA.9080602@magpie.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
---------------------------------------------=o&o>---------
Steve Manes http://www.magpie.com
Brooklyn, NY
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Marques | 2003-09-19 12:06:35 | Re: PostgreSQL versus MySQL |
Previous Message | Christopher Browne | 2003-09-19 11:37:54 | Re: need for in-place upgrades |