Re: Database schema & data synchronizer software for PostgreSQL?

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: Database schema & data synchronizer software for PostgreSQL?
Дата
Msg-id 20090120154406.GM20296@fetter.org
обсуждение исходный текст
Ответ на Database schema & data synchronizer software for PostgreSQL?  (Csaba Együd <csegyud@gmail.com>)
Ответы Re: Database schema & data synchronizer software for PostgreSQL?
Re: Database schema & data synchronizer software for PostgreSQL?
Список 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 по дате отправления:

Предыдущее
От: Grzegorz Jaśkiewicz
Дата:
Сообщение: Re: left join with smaller table or index on (XXX is not null) to avoid upsert
Следующее
От: Andreas Wenk
Дата:
Сообщение: Re: import sql dump with psql - language creation throws error