Thread: diff databases

Hi,

I'm looking for a tool which can compare structure of two databases 
and produce sql commands (ALTER, DROP, CREATE, etc. if needed) which 
could be used then to convert structure of one database to the other.

I would like to use such a tool for postgresql databases especially.

Daniel

EMS has a tool called EMS PostgreSQL Database Comparer.

http://www.sqlmanager.net/products/postgresql/dbcomparer

-----Original Message-----
From: drdani@mazsola.iit.uni-miskolc.hu
[mailto:drdani@mazsola.iit.uni-miskolc.hu]
Sent: Sunday, 19 December 2004 1:23 AM
To: pgsql-sql@postgresql.org
Subject: [SQL] diff databases


Hi,

I'm looking for a tool which can compare structure of two databases
and produce sql commands (ALTER, DROP, CREATE, etc. if needed) which
could be used then to convert structure of one database to the other.

I would like to use such a tool for postgresql databases especially.

Daniel

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org
______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright.  If you
have received this email in error, please advise the sender and delete
it.  If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone.  You must not copy or
communicate to others content that is confidential or subject to
copyright, unless you have the consent of the content owner.

On Saturday 18 December 2004 09:23, drdani@mazsola.iit.uni-miskolc.hu wrote:
> Hi,
>
> I'm looking for a tool which can compare structure of two databases
> and produce sql commands (ALTER, DROP, CREATE, etc. if needed) which
> could be used then to convert structure of one database to the other.
>
> I would like to use such a tool for postgresql databases especially.
>

Someone just asked this on the admin list the other day... do some archive 
checking for more thorough response.  Thats said, the best (and just about 
only) tool I have seen is by (iirc) ems hi-tech, see thier website for 
details. 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL