From: Arnau <arnaulist@andromeiberica.com>
To: pgsql-admin@postgresql.org
Subject: Re: Schema synchronization
Date: Thu, 20 Apr 2006 10:54:41 +0200
Message-ID: <44474C51.5010208@andromeiberica.com> (raw)
In-Reply-To: <2237D1DC-525A-4571-9F16-BC4E54D847D8@pgedit.com>
References: <444680F0.5000809@andromeiberica.com>
<2237D1DC-525A-4571-9F16-BC4E54D847D8@pgedit.com>
John DeSoi wrote:
>
> On Apr 19, 2006, at 2:26 PM, Arnau wrote:
>
>> I have several databases that I have to synchronize their schemas.
>> I have been testing several programs like EMS PostgreSQL Comparer and
>> Navicat PostgreSQL but none of them does all I need. Any advise about
>> what is the best way to sync the schemas?
>
>
> I think the best way is to do proper version control on files. After
> initial version 1, create version 2 as a series of create table, alter
> table, etc, statements to convert version 1 to version 2 and so on.
> Changing databases independently with your favorite admin tool and then
> trying to sync them up based on schema differences is difficult. For
> example, I don't think there is a way for a comparison program to know
> the difference between renaming a column and dropping a column with the
> addition a new one of the same type. The semantics of these two
> operations are very different.
I know that should be the way to go, but this wasn't done in the
past. Since now on we have a version control system. Now I have some
DDBB to synchronize so I need to do something to solve the current
situation.
Thanks
--
Arnau
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: arnaulist@andromeiberica.com
Subject: Re: Schema synchronization
In-Reply-To: <44474C51.5010208@andromeiberica.com>
References: <444680F0.5000809@andromeiberica.com> <2237D1DC-525A-4571-9F16-BC4E54D847D8@pgedit.com> <44474C51.5010208@andromeiberica.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox