Re: Database schema & data synchronizer software for PostgreSQL? - Mailing list pgsql-general

From David Fetter
Subject Re: Database schema & data synchronizer software for PostgreSQL?
Date
Msg-id 20090120154406.GM20296@fetter.org
Whole thread Raw
In response to Database schema & data synchronizer software for PostgreSQL?  (Csaba Együd <csegyud@gmail.com>)
Responses Re: Database schema & data synchronizer software for PostgreSQL?
Re: Database schema & data synchronizer software for PostgreSQL?
List pgsql-general
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.

Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: left join with smaller table or index on (XXX is not null) to avoid upsert
Next
From: Andreas Wenk
Date:
Subject: Re: import sql dump with psql - language creation throws error