Migration & upgrade hypersonic

We would like to upgrade hypersonic database for OD 6.0.2 to MySQL database. Are there any tools to extract the data from hypersonic database and load into MySQL db?
Any inputs/ideas are welcome.

Raj

Find more posts tagged with

Comments

Migrateduser

Hi Raj,

I'm not aware of any JDBC DB migration tools, but there is one "trick" that you could try. Hypersonic has a command to backup/dump the database to an SQL script.

Stop the AdminServer and run <adminhome>/odadmin/db/iwoddbtool
When it connects to hSqldb, type:

SCRIPT 'filename';
quit

Where filename is the name you want to give the backup SQL script. You might need to edit the SQL script a bit to make sure all of the datatypes are appropriate and all of the syntax is correct for your target database.

Good Luck!

Thanks,
Mike

--
Mike Szela
Sr. Member of Technical Staff
Interwoven, inc.