Skip site navigation (1) Skip section navigation (2)

Re: How to compare the schemas ?

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to compare the schemas ?
Date: 2005-06-28 08:24:58
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB167A6@neptun.sonorys.at (view raw or flat)
Thread:
Lists: pgsql-admin
diff speaks the wrong language to accomplish that, other elementry parts.

There exists a program named pgdiff on gborg.
On the other hand there's EMS database comparer http://www.sqlmanager.net/
 
|-----Original Message-----
|From: Milorad Poluga [mailto:milorad(dot)poluga(at)cores(dot)co(dot)yu]
|Sent: Donnerstag, 23. Juni 2005 16:11
|To: pgsql-admin(at)postgresql(dot)org
|Subject: [ADMIN] How to compare the schemas ?
|
|
|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(dot)poluga(at)cores(dot)co(dot)yu                      
|
|-- 
|---------------------------------------
|Milorad Poluga                        
|HK CORES Beograd, Makenzijeva 31
|milorad(dot)poluga(at)cores(dot)co(dot)yu                      
|+381-11-30-80-461              
|---------------------------------------
|
|
|---------------------------(end of 
|broadcast)---------------------------
|TIP 4: Don't 'kill -9' the postmaster
|

pgsql-admin by date

Next:From: Peter EisentrautDate: 2005-06-28 09:20:04
Subject: Re: How to compare the schemas ?
Previous:From: Michael FuhrDate: 2005-06-28 06:09:59
Subject: Re: moving database to diff. server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group