Re: Anyone know of a Schema Comparer

Hi Paul,

why not simply pg_dump your database and then restore only the chosen
schema on 2 new databases ?
Then you can use your software comparers.

Making a script that dump and restore only the chosen schemas should be 3
lines shell script.

Regards,
David

On Tue, Oct 25, 2005 at 07:19:57AM +0100, Paul Newman wrote:
> Hi,
>
> We will have anything upto 400 schema in our db. Each Schema is a
> replica of a "master" schema. Can anyone recommend a tool that we can
> compare our master schema to any given target schema which will then
> generate an update script which can subsequently be executed ? We have
> looked at EMS comparer and few others but all seem to compare one entire
> db with another.
>
>
>
> Regards
>
>
>
> Paul Newman
>

--
David Pradier -- Directeur Technique de Clarisys Informatique -- Chef de projet logiciels libres / open-source