Re: Database schema & data synchronizer software for PostgreSQL?

>-----Original Message-----
>From: David Fetter [mailto:david(at)fetter(dot)org]
>Sent: Tuesday, January 20, 2009 4:44 PM
>To: Csaba Együd
>Cc: pgsql-general(at)postgresql(dot)org
>Subject: Re: [GENERAL] Database schema & data synchronizer software for
>PostgreSQL?
>
>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.
>
>> It would be nice to be able to generate data synchronization script
>> for only the selected tables, and other features.
>
>Yes, you should definitely do that and store the scripts to do it in
>your source code management system along with all the rest of the
>deploy and upgrade scripts. They can't be generated automatically
>either.
>

David,
I see your points and generally can agree with, but there is a level which
can be automated - I mean a mechanic comparison.
Of course the result sync script must be tested before applying in
production environment. These tools can/could save a lot of time. In my
opinion the result, this way or that way, would be the same: a version
migration or sync script to attach to the upgrade package. I think the
difference is that I do not have to maintain a db script during the
development to keep it up to date. I simply concentrate on the task not the
administration. I may be wrong...

Up to now I've been doing it the manual way but it makes me really
non-effective.

Thank you,

-- Csaba