When using SchemaUpdate :

How can we output the result script to file ?
ex:
<schemaupdate
properties="${src}/hibernate.properties"
quiet="no"
text="yes"
output="${database.scripts}/update-schema.sql">
<fileset dir="${src}">
<include name="**/*.hbm.xml"/>
</fileset>
</schemaupdate>
This syntax doesn't work.

Just try the path without using a env variable, eg, /update-schema.sql see if that works for you.

Thanks David

I tried an explicit path but the "output" attribute doesn't exist, is there an other attribute that to the job.

The SchemaUpdateTask seems to have only the "quiet" and "text" options. I tried combinations of those attributes, I get the db statements print in the stdout and/or directly executed in the database, but I did not find the way to get the DB statements in a file .

returned error message:
file:myfile.xml:45:
The <schemaupdate> task doesn't support the "output" attribute. at line 45

Thanks

Yes your right I was thinking of hbm2ddl.
You can start by redirect standard output into a file.