From torque-user-return-7624-apmail-db-torque-user-archive=db.apache.org@db.apache.org Wed Aug 15 09:53:50 2007 Return-Path: Delivered-To: apmail-db-torque-user-archive@www.apache.org Received: (qmail 63760 invoked from network); 15 Aug 2007 09:53:44 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 15 Aug 2007 09:53:44 -0000 Received: (qmail 51414 invoked by uid 500); 15 Aug 2007 09:53:42 -0000 Delivered-To: apmail-db-torque-user-archive@db.apache.org Received: (qmail 51395 invoked by uid 500); 15 Aug 2007 09:53:42 -0000 Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Users List" Reply-To: "Apache Torque Users List" Delivered-To: mailing list torque-user@db.apache.org Received: (qmail 67410 invoked by uid 99); 15 Aug 2007 08:39:02 -0000 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of japher@hotmail.com designates 65.54.246.161 as permitted sender) Message-ID: Content-Type: multipart/alternative; boundary="_0080961c-8113-4cf9-bea5-83e9247da50f_" X-Originating-IP: [81.133.203.211] From: "Joe ." To: Subject: Generating upgrade scripts based on schema changes Date: Wed, 15 Aug 2007 08:38:34 +0000 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 15 Aug 2007 08:38:34.0846 (UTC) FILETIME=[AAF037E0:01C7DF17] X-Virus-Checked: Checked by ClamAV on apache.org --_0080961c-8113-4cf9-bea5-83e9247da50f_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi,We're currently using torque generator to create schema installation scr= ipts for Oracle, MS SQL Server and DB2 with great success. However, making = alterations to the schema and capturing these alterations in patch scripts = is still a very manual process.Does anyone know of any open source tools th= at can help with this task? Either by automatically generating the patch sc= ripts (based on comparison of two schemas), or by using some other means of= upgrading (such as a java process that runs and makes changes programmatic= ally). The scripts generated (or process run) would ideally be idempotent.T= hanks,Joe _________________________________________________________________ Feel like a local wherever you go with BackOfMyHand.com http://www.backofmyhand.com= --_0080961c-8113-4cf9-bea5-83e9247da50f_--