Re: [SQL] Postgres schema comparison.

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To:
Cc: pgsql-ADMIN(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Postgres schema comparison.
Date: 2005-03-09 10:39:01
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB16627@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql


|-----Original Message-----
|From: Goulet, Dick [mailto:DGoulet(at)vicr(dot)com]
|Sent: Montag, 07. März 2005 16:33
|To: John DeSoi; Stef
|Cc: pgsql-ADMIN(at)postgresql(dot)org; pgsql-sql(at)postgresql(dot)org
|Subject: Re: [SQL] [ADMIN] Postgres schema comparison.
|
|
| My favorite for this task is WinSql available from
|http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp. It
|can compare
|the structure and content of the two tables.

And will it also generate DIFF-SQL-Scripts to make a target-DB look like a
MasterDB?
Do you know? How about Structural Changes as adding a column?

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Rubio 2005-03-09 11:33:53 Re: Too many clients----A big problem for my team
Previous Message Eduardo Mambrilla Martínez 2005-03-09 07:32:00 How can I recreate the template0 database?

Browse pgsql-sql by date

  From Date Subject
Next Message Gary Stainburn 2005-03-09 12:41:55 order by question
Previous Message Richard Huxton 2005-03-09 09:57:29 Re: datestyle setting