This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JForum and the fly likes Migration from HSQLDB to ORACLE Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Migration from HSQLDB to ORACLE" Watch "Migration from HSQLDB to ORACLE" New topic
Author

Migration from HSQLDB to ORACLE

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hello,

i've an existing jforum with HSQLDB Database and i want to migrate to ORACLE.
How can i do this without losing my data ?

Thanks.

[originally posted on jforum.net by hpe]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I personally don't know any tool that I can recommend. Sorry.

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi,

We migrated from HSQLDB to PostgreSQL using SQuirreLSQL 2.6.4, but is a manual migration !!

Install jforum and use the wizard to create the database structure. later using Squirrel you can export the tables as a SQL script, and you can execute the script in the Oracle.


Regards,
Dani
[originally posted on jforum.net by gardan]
 
 
subject: Migration from HSQLDB to ORACLE
 
Similar Threads
HSQLDB and TO_DATE
About WRITE_DELAY
Need To Store Data, But cannot have a database
JBoss5.0GA+hsql have the following exception, When we shut down server .
Oracle 10g Plz