OD HyperSonic to SQL Server Conversion Process?

Is this process documented somewhere?

Thanks!

Find more posts tagged with

Comments

Don't think so. You would have to export and massage the data to then load it into SQL server as I think some of the data types are not compatible.

Migrateduser

In theory, you could convert the contents of the tables into select scripts and then just load those. I've attempted to use Squirrel to connect to the default hypersonic dbs that ship with TS and OD before, but I didn't have any luck with that - I think the default connection settings for Hypersonic in Squirrel are for a different version. In my case it was to answer a curiousity rather than for anything I really needed to do, so I only put about 10 minutes into it, then moved on to something else.

Migrateduser

Hopefully you mean the reporting database, because that is what I am going to describe here. I'm almost certian it is documented, but it isn't fun.

Make sure that the AdminServer is stopped, then cd to /odadmin/db. Try running this command:

iwoddbtool -sql hSqldb-bak.sql

If successful, it should create a file in the same directory named "hSqldb-bak.script". This file is basically an ANSI-92? SQL dump of commands to recreate the database, one command per-line, DDL first followed by inserts.

You may need to modify it slightly (especially the DDL and the statement termination) to get it to work for your database, but it should work.

Since I don't remember exactly in which version of OD we added the hSqldb-bak.sql script, the alternate procedure is to run iwoddbtool with no arguments:

iwoddbtool

Then at the prompt '>' type (NOTE: case is important):

SCRIPT 'hSqldb-bak.script';
bye

And you have the equivalent of running the hSqldb-bak.sql script.

Hope this helps!
-- Mike

P.S. If anyone has a nicer, cleaner way to do it, we're all ears!