pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feeddiff databases
3+ messages / 3 participants
[nested] [flat]
* diff databases
@ 2004-12-18 14:23 drdani@mazsola.iit.uni-miskolc.hu
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-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
* Re: diff databases
@ 2004-12-29 03:35 Robert Treat <xzilla@users.sourceforge.net>
parent: drdani@mazsola.iit.uni-miskolc.hu
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
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