db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Huang" <danih...@cisco.com>
Subject RE: using torgue to manage production schema change
Date Fri, 09 Apr 2004 15:53:16 GMT
Hi Thomas,

May I ask how big your project-data.xml is? Mine is 1.6M and datasql target
runs forever. Not really a feasible solution for me.

Besides, production data will keep growing, until some day it will become to
big for datadump target.

Thanks
Daniel

-----Original Message-----
From: Thomas Edwin Santosa [mailto:katalis@telkom.net]
Sent: Thursday, April 08, 2004 11:57 PM
To: Apache Torque Users List
Subject: Re: using torgue to manage production schema change

On Friday 09 April 2004 05:47, Daniel Huang wrote:
> Hi,
>
> Currently under torgen-gen 3.1, if you run
> ant -f build-torque.xml sql
>
> It will generate sql statements that drop tables and create new ones. This
> works great for development work. However, in a production environment,
> this is not feasible because it will just drop all data as well.
>
> It will be great if the ant sql target will be able to generate alter
table
> statements so that it is safe to apply the generated DDL to a production
> environment.
>
> Does this sound like a good enhancement idea for future releases?
I myself managed to do that using datadump sql datasql and insert-sql
target.

Thomas
>
> Thanks
> Daniel
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
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