X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EA9103AC039 for ; Wed, 29 Dec 2004 03:39:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82250-01 for ; Wed, 29 Dec 2004 03:38:55 +0000 (GMT) Received: from lakermmtao06.cox.net (lakermmtao06.cox.net [68.230.240.33]) by svr1.postgresql.org (Postfix) with ESMTP id E186B3ABF64 for ; Wed, 29 Dec 2004 03:38:58 +0000 (GMT) Received: from [192.168.0.8] (really [68.226.6.80]) by lakermmtao06.cox.net (InterMail vM.6.01.04.00 201-2131-117-20041022) with ESMTP id <20041229033857.WQQY22789.lakermmtao06.cox.net@[192.168.0.8]>; Tue, 28 Dec 2004 22:38:57 -0500 From: Robert Treat To: drdani@mazsola.iit.uni-miskolc.hu Subject: Re: diff databases Date: Tue, 28 Dec 2004 22:35:06 -0500 User-Agent: KMail/1.6.2 Cc: pgsql-sql@postgresql.org References: In-Reply-To: MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200412282235.06187.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/161 X-Sequence-Number: 19781 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