I paid $69 and purchased the EMS PostgreSQL DB Comparer tool.
Works great for me......
They have a trial version you can play with...
They even have a command line version......
http://www.sqlmanager.net/en/products/postgresql/dbcomparer
Peter Fein wrote:
See also the recent thread 'Version Control?' for some tools and a
discussion of some of the difficulties in doing this robustly.
Milorad Poluga wrote:
Hi everyone,
I am looking for the best way to compare the schemas of two databases with the very similar structure.
One (certainly not the best options) is to do something like this:
pg_dump ... DB1 > PG_SCHEMA1
pg_dump ... DB2 > PG_SCHEMA2
diff PG_SCHEMA1 PG_SCHEMA2 > differences.txt
kwrite differences.txt
Any suggestions or ideas on how to overcome this are welcome.
Thanks in advance,
Milorad Poluga
HK CORES Beograd, Makenzijeva 31
milorad.poluga@xxxxxxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
