Re: schema propagation

From: Markus Schiltknecht <markus(at)bluegap(dot)ch>
To: chester c young <chestercyoung(at)yahoo(dot)com>
Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: schema propagation
Date: 2007-06-06 12:12:28
Message-ID: 4666A4AC.8020706@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

chester c young wrote:
> has anyone done any work on comparing schemas?

There are two different projects called 'pgdiff', you'll find them with
google.

> I'm trying to automatically propagate changes in a master schema to
> child schemas. All schema changes will originate at master. Currently
> child schemas are in the same database, but in the future might be in
> different databases (clusters?).

Please note, that it's sometimes impossible to automatically convert
from one database schema to another. You should probably better use
proper change management processes.

Regards

Markus

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Loredana Curugiu 2007-06-06 12:46:26 Re: JOIN
Previous Message Drew 2007-06-06 08:46:14 Re: How to find missing values across multiple OUTER JOINs