| From: | Christophe <xof(at)thebuild(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Schema migration tools? |
| Date: | 2008-04-22 02:44:48 |
| Message-ID: | 2978A873-3DF9-47BF-A662-4185A2F4C46B@thebuild.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Greetings,
We have the traditional three servers:
dev --> staging --> production
each with a PostgreSQL instance and the same schema, at least over
time. Right now, we handle schema migration (updating the schema for
new releases) by manually-created scripts that apply the changes to
staging and production.
I'd like a tool that would automatically create these scripts, and I
wondered if anything like this existed. The theory would be that it
would consider two databases a and b, and produce the appropriate
script to change b's schema to match a.
Does anything like this exist? If not, I might have a new project...
Thanks!
-- Christophe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-04-22 02:48:39 | Re: Schema migration tools? |
| Previous Message | David Wilson | 2008-04-22 00:05:50 | Re: table as log (multiple writers and readers) |