Thread: Anyone know of a Schema Comparer
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
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 in a little script, that dumps the DDL (no data) of the two schemas and loads them into a sync_from and sync_to database. Not pretty, but works well. -- Regards, Hannes Dorbath
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