[jboss-user] [JBoss jBPM] - Re: Database change script from 3.1 to 3.2

[camunda]

Hi Ronald,

thanks for that hint! Don't know, why I didn't found that myself. Was a hard week I think....

I looked at that stuff a bit I could generate the update SLQ's for hsqldb with the following statements (in Windows):


  | ant -f build.upgrade.xml generate.old.schema
  | del target\db\localDB.lck
  | ant -f build.upgrade.xml generate.update > target/schema.upgrade.log
  | 

The batch file is not working (no idea why).

To generate updates for MySQL I have changed the ant file a bit (not catch the hibernate.cfg.xml's, so I could overwrite them with my own and added the mySQL driver to the classpath).

With that, I got some SQL's which have updated my database in about 5 minutes...

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4024842#4024842

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4024842