Re: Database schema & data synchronizer software for PostgreSQL?

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: David Fetter <david(at)fetter(dot)org>, Csaba Együd <csegyud(at)gmail(dot)com>
Subject: Re: Database schema & data synchronizer software for PostgreSQL?
Date: 2009-01-21 02:51:25
Message-ID: 200901202151.25702.xzilla@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

there are others too...

--
Robert Treat
Conjecture: http://www.xzilla.net
Consulting: http://www.omniti.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2009-01-21 03:05:20 Re: Is this on the to-do list?
Previous Message Luki Rustianto 2009-01-21 01:30:35 Re: How to find how much postgresql use the memory?