Take a look at the Apache DB subproject DDLUTILS. The API docs at http://db.apache.org/ddlutils/api-usage.html#Changing+a+database
seem to indicate it will do what you want. Plus they use the same XML format as Torque does. If that won't work, I know there are several fairly low cost commercial tools that will do this for different DBs. I have used one (I think it was DBSolo) for MS SQL that generated a nice script you could run to update a DB SCHEMA. > -----Original Message----- > From: Joe . [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 15, 2007 4:39 AM > To: torque-user@db.apache.org > Subject: Generating upgrade scripts based on schema changes > > > Hi,We're currently using torque generator to create schema > installation scripts 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 that > can help with this task? Either by automatically generating > the patch scripts (based on comparison of two schemas), or by > using some other means of upgrading (such as a java process > that runs and makes changes programmatically). The scripts > generated (or process run) would ideally be idempotent.Thanks,Joe > _________________________________________________________________ > Feel like a local wherever you go with BackOfMyHand.com > http://www.backofmyhand.com > DukeCE Privacy Statement: Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
