On Jan 20, 2009, at 11:27 PM, Együd Csaba wrote:
-----Original Message-----
From: Robert Treat [mailto:xzilla@xxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, January 21, 2009 3:51 AM
To: pgsql-general@xxxxxxxxxxxxxx
Cc: David Fetter; Csaba Együd
Subject: Re: Database schema & data synchronizer software
for
PostgreSQL?
On Tuesday 20 January 2009 10:44:06 David Fetter wrote:
On Tue, Jan 20, 2009 at 03:03:33PM +0100, Csaba Együd wrote:
Hi,
I'd like to ask your suggestions about a reliable admin software
which is able to compare two dabases and generate a schema
synchrinizer script.
There is no such thing, and there is no prospect of there ever being
such a thing, because the database does not contain enough
information
to create this automatically. The problem exists at the
organizational level, and needs to be solved there.
While I would agree that these tools can't solve organizational
problems,
they
do exist:
http://pgdiff.sourceforge.net/
http://apgdiff.sourceforge.net/
http://www.dbsolo.com/
http://sqlmanager.net/en/products/postgresql/dbcomparer
Robert,
Thank you for your suggestions. I will glace at them.
-- Csaba
dbsolo does a decent job.
I think they main thing here is to check for inconsistencies and see
what they are, rather
then a tool that takes over the administrative task.
We all understand David's point of view, but it can't hurt to have a
tool in place that can verify the consistency of both schema's.
Ries
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
