Re: [GENERAL] Anyone know of a Schema Comparer

2005-10-25 Thread David Pradier
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 +0

Re: [GENERAL] Anyone know of a Schema Comparer

2005-10-25 Thread Hannes Dorbath
On 25.10.2005 08:19, Paul Newman wrote: We have looked at EMS comparer and few others but all seem to compare one entire db with another. We had the same problem. EMS DB comparer has this limitation, but it's probably the best tool out there. We solved it be wrapping the command line version

[GENERAL] Anyone know of a Schema Comparer

2005-10-24 Thread Paul Newman
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