| 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: | Whole Thread | Raw Message | 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 |