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

Hi, is there a way to compare 2 DB schema and obtain an sql script to align the DBs?<br /><div
class="moz-signature">--<br /></div><div class="Section1"><p style="margin: 0cm 0cm
0.0001pt;">______________________________________<pstyle="margin: 0cm 0cm 0.0001pt;"><b>Ing. Erasmo Zottola</b><p
style="margin:0cm 0cm 0.0001pt;"><i><span style="font-size:             10pt;">R & D: Software
Designer</span></i><pstyle="margin: 0cm 0cm 0.0001pt;">______________________________________<p style="margin: 0cm 0cm
0.0001pt;"><b>ELMANS.r.l.</b><p style="margin: 0cm 0cm 0.0001pt;">Via di Valle Caia, km 4,700 - Z.I. S. Palomba<p
style="margin:0cm 0cm 0.0001pt;">00040  Pomezia (ROMA) - ITALY<p style="margin: 0cm 0cm 0.0001pt;"><span
style="font-size:          3pt; font-family: "Wingdings 2"; color: navy;"> </span><span style="font-family: "Wingdings
2";color: navy;">(</span>      +39.069194405<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family:
"Wingdings2"; color: navy;">6</span>     +39.069194306<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family:
      Webdings; color: navy;">þ</span>     <a href="http://www.elmansrl.it">www.elmansrl.it</a><p style="margin: 0cm
0cm0.0001pt;"><span style="font-family:           Wingdings;">*</span>    <a
href="mailto:e.zottola@elmansrl.it">e.zottola@elmansrl.it</a><pstyle="margin: 0cm 0cm
0.0001pt;">______________________________________ <p style="margin: 0cm 0cm 0.0001pt;"> <p style="margin: 0cm 0cm
0.0001pt;"><spanstyle="font-size:           10pt;">RISERVATEZZA</span><p style="margin: 0cm 0cm 0.0001pt;"><span
style="font-size:          10pt;">__________________________________________________________________________</span><p
style="margin:0cm 0cm 0.0001pt;"><span style="font-size:           10pt;">Ai sensi del D.lgs n. 196 del 30/06/2003
(CodicePrivacy) si precisa che le informazioni contenute </span><p style="margin: 0cm 0cm 0.0001pt;"><span
style="font-size:          10pt;">in questo messaggio sono riservate e ad uso esclusivo del destinatario.</span><p
style="margin:0cm 0cm 0.0001pt;"><span style="font-size:           10pt;">Qualora il messaggio in parola Le fosse
pervenutoper errore, La preghiamo di eliminarlo senza</span><div style="border-width: medium medium 1.5pt;
border-style:        none none solid; border-color: -moz-use-text-color         -moz-use-text-color windowtext;
padding:0cm 0cm 3pt;"><p style="margin: 0cm 0cm 0.0001pt;"><span style="font-size:             10pt;">copiarlo e di non
inoltrarloa terzi, dandocene gentilmente comunicazione. Grazie.</span></div></div> 

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

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