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
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
