Re: Database schema & data synchronizer software for PostgreSQL?

On Jan 20, 2009, at 11:27 PM, Együd Csaba wrote:

>> -----Original Message-----
>> From: Robert Treat [mailto:xzilla@users.sourceforge.net]
>> Sent: Wednesday, January 21, 2009 3:51 AM
>> To: pgsql-general@postgresql.org
>> Cc: David Fetter; Csaba Együd
>> Subject: Re: [GENERAL] 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