pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
diff databases
3+ messages / 3 participants
[nested] [flat]

* diff databases
@ 2004-12-18 14:23 drdani@mazsola.iit.uni-miskolc.hu
  2004-12-29 03:35 ` Re: diff databases Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 1 reply; 3+ messages in thread

From: drdani@mazsola.iit.uni-miskolc.hu @ 2004-12-18 14:23 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: diff databases
  2004-12-18 14:23 diff databases drdani@mazsola.iit.uni-miskolc.hu
@ 2004-12-29 03:35 ` Robert Treat <xzilla@users.sourceforge.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Robert Treat @ 2004-12-29 03:35 UTC (permalink / raw)
  To: drdani@mazsola.iit.uni-miskolc.hu; +Cc: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: diff databases
@ 2004-12-21 05:25 Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>
  0 siblings, 0 replies; 3+ messages in thread

From: Theo Galanakis @ 2004-12-21 05:25 UTC (permalink / raw)
  To: 'drdani@mazsola.iit.uni-miskolc.hu' <drdani@mazsola.iit.uni-miskolc.hu>; +Cc: pgsql-sql

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.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-12-29 03:35 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-18 14:23 diff databases drdani@mazsola.iit.uni-miskolc.hu
2004-12-29 03:35 ` Robert Treat <xzilla@users.sourceforge.net>
2004-12-21 05:25 Re: diff databases Theo Galanakis <Theo.Galanakis@lonelyplanet.com.au>

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