db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Greg Monroe" <Greg.Mon...@DukeCE.com>
Subject RE: Generating upgrade scripts based on schema changes
Date Wed, 15 Aug 2007 16:52:53 GMT
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:japher@hotmail.com] 
> 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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message