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 5C1CD5E46F5 for ; Thu, 26 Aug 2004 10:07:38 -0300 (ADT) 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 46011-01 for ; Thu, 26 Aug 2004 13:07:38 +0000 (GMT) Received: from n33.kp.t-systems-sfr.com (n33.kp.t-systems-sfr.com [129.247.16.33]) by svr1.postgresql.org (Postfix) with ESMTP id 93DEA5E46F4 for ; Thu, 26 Aug 2004 10:07:32 -0300 (ADT) Received: from sea-gw.sea.com (yyy.kp.dlr.de [129.247.113.223]) by n33.kp.t-systems-sfr.com (8.11.7-20030917/8.11.7) with ESMTP id i7QD7a2260912 for ; Thu, 26 Aug 2004 15:07:36 +0200 Received: from joelap (Joelap.sea.com [192.168.0.21]) by sea-gw.sea.com (Postfix) with ESMTP id D437849801D for ; Thu, 26 Aug 2004 15:07:35 +0200 (CEST) From: Joerg Hessdoerfer Organization: S.E.A Datentechnik GmbH To: pgsql-sql@postgresql.org Subject: Auto-update script from dumps? Date: Thu, 26 Aug 2004 15:06:53 +0200 User-Agent: KMail/1.6.2 References: <20040826120504.58934.qmail@web13925.mail.yahoo.com> In-Reply-To: <20040826120504.58934.qmail@web13925.mail.yahoo.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Message-Id: <200408261506.53524.Joerg.Hessdoerfer@sea-gmbh.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/289 X-Sequence-Number: 18786 Hi! What I'm looking for is something that handles DB schema upgrades. We're building applications which require upgrades to the DB schema over time, so when we upgrade our apps we need to modify the DB. For this, we're using SQL scripts, which basically do incremental updates, e.g. from 1.2 to 1.3. So when we upgrade FooBar Version 2.3, which uses DB schema 1.3 to Version 3.9, which uses DB schema 1.9 we would run 6 scripts, and voila, we would have a 1.9 schema. OK, sounds simple. But it's sometimes a lot of work to build the update script, and easy to miss something. So I was just thinking whether there's a tool or script out there that builds an update script from two different schema dumps. Does anyone out there know of such a beast? Greetings, Jörg -- Leading SW developer - S.E.A GmbH Mail: joerg.hessdoerfer@sea-gmbh.com WWW: http://www.sea-gmbh.com