Migration from an Oracle Database to a H2 Database

224 views
Skip to first unread message

Last Warrior

unread,
Mar 16, 2017, 5:05:12 AM3/16/17
to H2 Database
Hi everyone, 

I have currently an Oracle Database and would like to migrate it into H2. 

Any ideas how to achieve this??

Thanks in advance,
Philipp

Christian MICHON

unread,
Mar 17, 2017, 2:31:03 AM3/17/17
to H2 Database
Hi

From a pure java technology, you would need to first recreate the complete DDL from the source DB to the destination DB. Then use for example an ETL to load all records.

Another possible route is to use linked tables. But you'll miss out on indexes and referential constraints unless you already copied the DDL.

If you're interested in using Sequel with jruby, this ruby gem executable can perform most operations for you.

Reply all
Reply to author
Forward
0 new messages