pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Schema 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