From: | ries van Twisk <pg(at)rvt(dot)dds(dot)nl> |
---|---|
To: | Együd Csaba <csegyud(at)gmail(dot)com> |
Cc: | "'Robert Treat'" <xzilla(at)users(dot)sourceforge(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Database schema & data synchronizer software for PostgreSQL? |
Date: | 2009-01-21 05:10:21 |
Message-ID: | 2198ABBC-A476-4FB2-9D84-16E60F65669E@rvt.dds.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Jan 20, 2009, at 11:27 PM, Együd Csaba wrote:
>> -----Original Message-----
>> From: Robert Treat [mailto:xzilla(at)users(dot)sourceforge(dot)net]
>> Sent: Wednesday, January 21, 2009 3:51 AM
>> To: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Együd Csaba | 2009-01-21 05:51:40 | Re: Database schema & data synchronizer software for PostgreSQL? |
Previous Message | Együd Csaba | 2009-01-21 04:27:08 | Re: Database schema & data synchronizer software for PostgreSQL? |