ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Java Jboss <apache...@hotmail.co.uk>
Subject How to script database upgrade using ANT script
Date Thu, 04 Nov 2010 16:28:02 GMT

Hi,

I’m a complete newbie to ANT and 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 database version
4) then check if sql script1 exists
4.1) if "No" then check for next sql script until it has checked for all
scripts then "end"
4.2) if "yes" then run first sql script then check if second sql script
exists - if "yes" then run second sql script and so on until the required
database version is reached.
5) check database version is at correct level then “end” or else start the
loop again 
6) how can I script error checking also

Thank you all in advance.

-- 
View this message in context: http://ant.1045680.n5.nabble.com/How-to-script-database-upgrade-using-ANT-script-tp3250375p3250375.html
Sent from the Ant - Users mailing list archive at Nabble.com.

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


Mime
View raw message