Обсуждение: Maintaining production DBs, making one schema look like the other

Поиск
Список
Период
Сортировка

Maintaining production DBs, making one schema look like the other

От
KÖPFERL Robert
Дата:
OK, the usual thing:
There exists a DB-schema. It is on one hand already in production usage. On
the other hand it is still being developed as functions and non-structural
stuff are concerned.

I found out that EMS Database Comparer helps to replicate the schema
differences in form of SQL-statements. From my view this seems to be what I
want.

What is the psql-way to address this problem?
How does one maintain two schemas with PostgreSQL/ are there other tools?