pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Tool to compare db schemas?
3+ messages / 3 participants
[nested] [flat]

* Tool to compare db schemas?
@ 2004-05-04 17:37 Chris Hoover <revoohc@sermonaudio.com>
  2004-05-05 09:25 ` Re: Tool to compare db schemas? CoL <col@mportal.hu>
  2004-05-05 16:06 ` Re: Tool to compare db schemas? Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 2 replies; 3+ messages in thread

From: Chris Hoover @ 2004-05-04 17:37 UTC (permalink / raw)
  To: pgsql-admin

Does anyone know of a good tool to compare db schemas?  I have over 200 db's 
that should all have identical schemas and have been asked to report on the 
differences.

Thanks,

Chris




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Tool to compare db schemas?
  2004-05-04 17:37 Tool to compare db schemas? Chris Hoover <revoohc@sermonaudio.com>
@ 2004-05-05 09:25 ` CoL <col@mportal.hu>
  1 sibling, 0 replies; 3+ messages in thread

From: CoL @ 2004-05-05 09:25 UTC (permalink / raw)
  To: pgsql-admin

hi,

Chris Hoover wrote:

> Does anyone know of a good tool to compare db schemas?  I have over 200 db's 
> that should all have identical schemas and have been asked to report on the 
> differences.

if you looking for a program, check
http://ems-hitech.com/pgsqlutils/index.phtml#pgcomparer

but you can write your own scripts to compare schemas, even in plpgsql 
too with different servers (using dblink)

C.



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Tool to compare db schemas?
  2004-05-04 17:37 Tool to compare db schemas? Chris Hoover <revoohc@sermonaudio.com>
@ 2004-05-05 16:06 ` Robert Treat <xzilla@users.sourceforge.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Robert Treat @ 2004-05-05 16:06 UTC (permalink / raw)
  To: Chris Hoover <revoohc@sermonaudio.com>; +Cc: pgsql-admin

On Tue, 2004-05-04 at 13:37, Chris Hoover wrote:
> Does anyone know of a good tool to compare db schemas?  I have over 200 db's 
> that should all have identical schemas and have been asked to report on the 
> differences.
> 

http://pgdiff.sourceforge.net/
http://gborg.postgresql.org/project/pgdiff/projdisplay.php

If you run across any others please lmk, I think I'm going to need this
for a project in the next few days. 

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-05-05 16:06 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-04 17:37 Tool to compare db schemas? Chris Hoover <revoohc@sermonaudio.com>
2004-05-05 09:25 ` CoL <col@mportal.hu>
2004-05-05 16:06 ` Robert Treat <xzilla@users.sourceforge.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox