Re: Upgrading an old database

John Lussmyer wrote:
> I'm working on upgrading our desktop application from HSQLDB 1.8 to 
> 2.5.
> That's a BIG jump.
> .
> .
> java.sql.SQLSyntaxErrorException: user lacks privilege or object not 
> found: STUFF

Seems to me yes there were big changes from v1 to v2 and my application
had major changes and it may not connect to v1 databases anymore.

Did you look for object STUFF?

> Also, is there ANY way to get hsqldb to upgrade the DB without manually 
> editing
> the .script file?

Can you just dump the data, to SQL or CSV format, and then import it 
into a
new v2.5 database?

danap.