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