pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTool 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