synchronize DTAP

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема synchronize DTAP
Дата
Msg-id CAHnozTgxuV6vu0kN18HFJZKxEAY8orGHUwK9ebYfbU0Rs2xhVg@mail.gmail.com
обсуждение исходный текст
Ответы Re: synchronize DTAP
Список pgsql-general
Дерево обсуждения
Hi,

We have an environment that has a central repository for lookups, which is replicated to several databases, ech for different applications.
This has been arranged in a DTAP manner.

Sometimes it is necessary to synchronize the lookups of one of the DTAP branches with another. But i can't just overwrite one database with a dump from another branch, as the consumer databases will not follow.
What i think i need is a way to compute the differences between two databases that have the same schema, and generate insert/update/delete statements from that.

Since this seems as a pretty generic problem, i thought that i should ask around before i start writing my own scripts. Does anyone know of script or application that does this?

Cheers
--
Willy-Bas Loos

В списке pgsql-general по дате отправления: