From: Matteo Beccati <php@beccati.com>
To: Stef <svb@ucs.co.za>
Cc: pgsql-ADMIN@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Postgres schema comparison.
Date: Tue, 08 Mar 2005 09:59:20 +0100
Message-ID: <422D6968.4070000@beccati.com> (raw)
In-Reply-To: <20050307113312.2200b65c@svb.ucs.co.za>
References: <20050307113312.2200b65c@svb.ucs.co.za>
Hi,
> I have the wonderful job of re-synch'ing all the schemas out there not
> conforming to the master. I've looked everywhere for something that
> will help doing this. I'm specifically looking for a way to do a sumcheck
> or something similar on tables and/or schema as a whole to be able to
> do a table comparison with the master database.
>
> It will be a bonus to pick up exactly what is missing, but for now, just identifying
> differences is what I want to achieve. I'm using postgres 7.3 mostly, but
> I may want to use this for 7.4 and 8.0 databases as well.
>
> Has anybody got some suggestions of what I can do or use to do this.
I've made a simple PHP script which compares the schemas of two
databases. It was made in a hurry and is far from being complete, but it
works for my purposes :)
If you want give it a try, let me know
Best regards
--
Matteo Beccati
http://phpadsnew.comhttp://phppgads.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: php@beccati.com, svb@ucs.co.za, pgsql-ADMIN@postgresql.org
Subject: Re: Postgres schema comparison.
In-Reply-To: <422D6968.4070000@beccati.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox