Maintaining production DBs, making one schema look like the other

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Maintaining production DBs, making one schema look like the other
Date: 2005-03-07 13:03:09
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB1661E@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Browse pgsql-sql by date

  From Date Subject
Next Message Richard_D_Levine 2005-03-07 13:03:43 Re: [SQL] Postgres schema comparison.
Previous Message Stef 2005-03-07 12:54:44 Re: [SQL] Postgres schema comparison.