Re: Ant task for database script

Bhavin wrote:

Has anybody worked on ant script for executing the database scripts.

I'm experimenting with it. Mainly to manage remote upgrades of
customers, to apply a bunch of individual bug fixes to them.

Fixes are stored in Subversion, which I query with Python to make an
RDF/XML document. This is then transformed by XSLT into an Ant script.
Each script maps to an Ant target.

I get two benefits from Ant:
- It's a competent SQL client that uses JDBC to connect to the DB. Our
main app is in Java / JDBC, so we can already assuem this is available.
We've had a lot of past trouble with varying behaviours under different
interactive SQL client tools.

- Ant does dependency management. If I annotate a patch script in
Subversion (I store Dublin Core on them as SVN properties) then I can
extract this into my RDF/XML document, then pass the dependency through
to Ant. Ant does the rest.

Ant also lets me use a "dry run" property to list the script names out
in sequence, without actually running them

.

Quantcast