RE: How to script database upgrade using ANT script

2010-11-09 Thread Ludwig, Michael
> I have tried using the and other examples > from Google but I can't get it to work. Then you should try a little harder, it is not difficult, certainly way less difficult than anything involving JBoss. Start with a minimum script and the Ant manual. You shouldn't need more. Good luck, Michael

RE: How to script database upgrade using ANT script

2010-11-09 Thread Java Jboss
Hi Michael, I have tried using the and other examples from Google but I can't get it to work. I just want the "db-upgrade:" bit to stop when it cant meet the next condition. At the moment it still tries to run the script looking for dir2 and dir3 even though these don't exist at the moment bu

RE: How to script database upgrade using ANT script

2010-11-09 Thread Ludwig, Michael
> having difficulty scripting a > routine to tell it that when a condition is not met it should exit. Look at the docs for to see how to set the property. Michael - To unsubscribe, e-mail: user-unsubscr...@ant.apache.org For

Re: How to script database upgrade using ANT script

2010-11-09 Thread Java Jboss
Hi Michael, With my limited ANT knowledge I have got the script to work almost. I have had a look at the link that you sent but having difficulty scripting a routine to tell it that when a condition is not met it should exit. I would really appreciate a soultion for this. I need to get this imp

RE: How to script database upgrade using ANT script

2010-11-09 Thread Ludwig, Michael
I commented on the task: > Note that the first example given in the manual is sort of > stupid, as it is wasteful to call "ls -l" once for each file > in a list of possibly hundreds of files, spawning a new > process each time around. You can have Ant execute the batch all at once by supplying:

Re: How to script database upgrade using ANT script

2010-11-08 Thread Robert Kirkpatrick
You should really get rid of the exec task and use the Ant sql task instead. It just requires a JDBC driver. Suitable parameters exist for all your args. Robert. Le 8/11/2010 16:19, Java Jboss a écrit : Hi, Thank you to all for the suggestions. I have now got an ANT script that checks the

Re: How to script database upgrade using ANT script

2010-11-08 Thread Mugdha Acharya
We are using dbdeploy and are very happy with the results. You can read more about it at http://dbdeploy.com/ On Mon, 2010-11-08 at 07:19 -0800, Java Jboss wrote: > Hi, > > Thank you to all for the suggestions. I have now

Re: How to script database upgrade using ANT script

2010-11-08 Thread Java Jboss
Hi, Thank you to all for the suggestions. I have now got an ANT script that checks the current database version and then runs a set of mysql scripts to upgrade the database to the next version. What I am struggling with is when it goes through the list="${db.upgrade.path.list}. On the first ru

Re : How to script database upgrade using ANT script

2010-11-08 Thread Hoang-Vu PHUNG
Hi, Select the right tool for the right job: For example scriptella http://scriptella.javaforge.com/ is a good tool for upgrading database. And i think it does have an ant task also. Please check with the site. Regards, Vu --- En date de : Jeu 4.11.10, Java Jboss a écrit : > De: Java Jboss >

Re: How to script database upgrade using ANT script

2010-11-05 Thread Gilbert Rebhan
Original Message Subject: Re: How to script database upgrade using ANT script From: Java Jboss To: user@ant.apache.org Date: 05.11.2010 11:48 > This is rather urgent so I would appreciate any assistance. I need to create > a recursive loop which I can't do and also

Re: How to script database upgrade using ANT script

2010-11-05 Thread Brian Pontarelli
There are a number of projects for this as well. Here's one I know of: https://github.com/ReadyTalk/staccato There are a number of others out there as well. I'd suggest trying on of these projects to do your migrations and version checking because you'll run into maintenance nightmares otherwis

RE: How to script database upgrade using ANT script

2010-11-05 Thread Ludwig, Michael
> can you please provide an example of how I could do this? If you didn't top-post, it'd be easier to read your mail. Take a look at the documentation for the task in the manual. Well, scroll down to the example section. Looks like the task applies the command to each file in the nested . Which

RE: How to script database upgrade using ANT script

2010-11-05 Thread Java Jboss
Hi Darragh, can you please provide an example of how I could do this? Date: Fri, 5 Nov 2010 03:49:57 -0700 From: ml-node+3251630-1672610580-143...@n5.nabble.com To: apache...@hotmail.co.uk Subject: RE: How to script database upgrade using ANT script > -Original Mess

Re: How to script database upgrade using ANT script

2010-11-05 Thread Antoine Levy Lambert
On 11/5/10 6:48 AM, Java Jboss wrote: Hi, Thank you for the suggestions so far from Antoine and Michael. unfortunately I've been asked to use ANT only without using unix shell scripts. I have tried to tackle it as individual modules using ANT script running the 1st iteration of the mysql scrip

RE: How to script database upgrade using ANT script

2010-11-05 Thread Bailey, Darragh
> -Original Message- > From: Java Jboss [mailto:apache...@hotmail.co.uk] > Sent: 04 November 2010 22:43 > To: user@ant.apache.org > Subject: RE: How to script database upgrade using ANT script > > > > Hi Antoine, > > Thank you very m

Re: How to script database upgrade using ANT script

2010-11-05 Thread Java Jboss
Hi, Thank you for the suggestions so far from Antoine and Michael. unfortunately I've been asked to use ANT only without using unix shell scripts. I have tried to tackle it as individual modules using ANT script running the 1st iteration of the mysql scripts against newschema1. I need to run e

RE: How to script database upgrade using ANT script

2010-11-04 Thread Java Jboss
ning sql in dir Running sql in dir Date: Thu, 4 Nov 2010 10:45:35 -0700 From: ml-node+3250502-1415855530-143...@n5.nabble.com To: apache...@hotmail.co.uk Subject: Re: How to script database upgrade using ANT script On 11/4/10 1:35 PM, J

Re: How to script database upgrade using ANT script

2010-11-04 Thread Antoine Levy Lambert
50409-888287632-143...@n5.nabble.com To: apache...@hotmail.co.uk Subject: Re: How to script database upgrade using ANT script Hi, you will need to use the task for steps like creating the database and importing the dump into the new schema. Once your database is up, you can use the task to run DD

RE: How to script database upgrade using ANT script

2010-11-04 Thread Java Jboss
for help. Thank you. Date: Thu, 4 Nov 2010 09:46:31 -0700 From: ml-node+3250409-888287632-143...@n5.nabble.com To: apache...@hotmail.co.uk Subject: Re: How to script database upgrade using ANT script Hi, you will need to use the task for steps like creating the database and importing the

Re: How to script database upgrade using ANT script

2010-11-04 Thread Antoine Levy Lambert
Hi, you will need to use the task for steps like creating the database and importing the dump into the new schema. Once your database is up, you can use the task to run DDL and DML statements. To check whether a script exists, there is a task called which can set a property if a file is ava

RE: How to script database upgrade using ANT script

2010-11-04 Thread Ludwig, Michael
> I need to write an ant script which upgrades a database version from > base level 1.00 to a given version number by running a series of mysql > (ver 5.1.45) scripts. > > Using ANT script I need to: > 1) create a database > 2) import mysql database(s) dump to a new schema > 3) check current datab