Is there a way that I can get the schema update script instead of updating the schema against the database directly?

Thanks,

Personally I never go directly - always get the script (and modify as appropriate).

See the documentation for the options.

http://www.hibernate.org/hib_docs/v3/reference/en/html/toolsetguide.html#toolsetguide-s1-6

David, Thank you for your reply. But I am using the new HibernateTool, here is my ant script:

<taskdef name="hibernatetool"
classname="org.hibernate.tool.ant.HibernateToolTask"
classpathref="ejb3toolslib" />

<hibernatetool destdir="Docs">
<jpaconfiguration persistenceunit="em"/>
<classpath>
<path location="bin/classes" />
</classpath>
<hbm2ddl export="false" update="true" format="true" outputfilename="updatescript.ddl"/>
</hibernatetool>

I was expecting an schema update script been generated but it's not.

On the surface it looks OK. I dont have time to try it out at the moment. Maybe later - or Max will come in and help.

BTW: Have you tried getting it to dump the whole schema (update="false") and does the script get created?

Yes, I tried with update="false". The script is generated but this is for everything.

could you be a tad more specific on what is wrong with update script ?

I had the same problem -- no output file !?! So I turned on logging and voila, the update script statements appeared in the log file. I run HBM2DDL via "ant" and I had to specify the following within the ant target definition :

<record name="schemaupdate.log" loglevel="debug"/>

The loglevel can also be set to "info" and the update stmts still appear. I also found the statements scrolling on my command window (win xp). The rest of my ant parms are set to this :

<hbm2ddl
outputfilename="schemaupdate.sql"
export="false"
update="true"
drop="true"
create="true"
delimiter="${db.gen.delimiter}"
/>

The "db.gen.delimiter" variable is defined earlier as a semi-colon. I'm not sure if the "drop" and "create" parms do anything, but I left them in anyway.

I had the same problem -- no output file !?! So I turned on logging and voila, the update script statements appeared in the log file. I run HBM2DDL via "ant" and I had to specify the following within the ant target definition :

<record name="schemaupdate.log" loglevel="debug"/>

The loglevel can also be set to "info" and the update stmts still appear. I also found the statements scrolling on my command window (win xp). The rest of my ant parms are set to this :

<hbm2ddl
outputfilename="schemaupdate.sql"
export="false"
update="true"
drop="true"
create="true"
delimiter="${db.gen.delimiter}"
/>

The "db.gen.delimiter" variable is defined earlier as a semi-colon. I'm not sure if the "drop" and "create" parms do anything, but I left them in anyway.