Обсуждение: Compare DB schema

Поиск
Список
Период
Сортировка

Compare DB schema

От
Erasmo Zottola - Elman
Дата:
Hi, is there a way to compare 2 DB schema and obtain an sql script to align the DBs?
--

______________________________________

Ing. Erasmo Zottola

R & D: Software Designer

______________________________________

ELMAN S.r.l.

Via di Valle Caia, km 4,700 - Z.I. S. Palomba

00040  Pomezia (ROMA) - ITALY

 (      +39.069194405

6     +39.069194306

þ     www.elmansrl.it

*    e.zottola@elmansrl.it

______________________________________ 

 

RISERVATEZZA

__________________________________________________________________________

Ai sensi del D.lgs n. 196 del 30/06/2003 (Codice Privacy) si precisa che le informazioni contenute

in questo messaggio sono riservate e ad uso esclusivo del destinatario.

Qualora il messaggio in parola Le fosse pervenuto per errore, La preghiamo di eliminarlo senza

copiarlo e di non inoltrarlo a terzi, dandocene gentilmente comunicazione. Grazie.

Re: Compare DB schema

От
Raymond O'Donnell
Дата:
On 16/12/2010 10:20, Erasmo Zottola - Elman wrote:
> Hi, is there a way to compare 2 DB schema and obtain an sql script to
> align the DBs?

Hi there,

There is a good number of tools out there to do that sort of thing. 
Googling "Postgresql schema diff" throws up a few to start with.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie


Re: Compare DB schema

От
Devrim GÜNDÜZ
Дата:
On Thu, 2010-12-16 at 11:20 +0100, Erasmo Zottola - Elman wrote:
> Hi, is there a way to compare 2 DB schema and obtain an sql script to
> align the DBs?

You may want to look at

http://pgfoundry.org/projects/pg-comparator

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz