I move a DB structure from Oracle 11g to HSQLDB embedded throught java code.
I create the Oracle DB in SQL Developer, then mapping the DB throught NetBeans in java class.
Now I create from this structure an embedded DB in HSQLDB at the run of my application.
I have this problem:
When I change my Oracle DB structure, I recreate the class of my persistence throught NetBeans, but now if i try to read an HSQLDB file already created with the old class of persistence it doesn't work, beacause the DB doesn't represent the structure of class.
There is a way to update the DB HSQLDB from the new schema without writing manually the ALTER TABLE query? and without losing any data?