pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSchema synchronization
3+ messages / 2 participants
[nested] [flat]
* Schema synchronization
@ 2006-04-19 18:26 Arnau <arnaulist@andromeiberica.com>
0 siblings, 1 reply; 3+ messages in thread
From: Arnau @ 2006-04-19 18:26 UTC (permalink / raw)
To: pgsql-admin
Hi all,
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?
Thanks
--
Arnau
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Schema synchronization
@ 2006-04-20 00:45 John DeSoi <desoi@pgedit.com>
parent: Arnau <arnaulist@andromeiberica.com>
0 siblings, 1 reply; 3+ messages in thread
From: John DeSoi @ 2006-04-20 00:45 UTC (permalink / raw)
To: arnaulist@andromeiberica.com; +Cc: pgsql-admin
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.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Schema synchronization
@ 2006-04-20 08:54 Arnau <arnaulist@andromeiberica.com>
parent: John DeSoi <desoi@pgedit.com>
0 siblings, 0 replies; 3+ messages in thread
From: Arnau @ 2006-04-20 08:54 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2006-04-20 08:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-04-19 18:26 Schema synchronization Arnau <arnaulist@andromeiberica.com>
2006-04-20 00:45 ` John DeSoi <desoi@pgedit.com>
2006-04-20 08:54 ` Arnau <arnaulist@andromeiberica.com>
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