db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bogdan Vatkov" <bvat...@globaltech-bg.com>
Subject Re: using torgue to manage production schema change
Date Fri, 09 Apr 2004 15:56:51 GMT
Hi,
I recommend you to use native (console ) tools for
dump/restore the data (not the structure of the database)

XML oriented one is not a good idea. (or at least unless you have 1-2 GB
RAM)
regards,
bogdan
----- Original Message -----
From: "Daniel Huang" <danihuan@cisco.com>
To: "Apache Torque Users List" <torque-user@db.apache.org>
Sent: Friday, April 09, 2004 6:53 PM
Subject: RE: using torgue to manage production schema change


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


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