This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes How to copy Oracle tables in HSQL DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "How to copy Oracle tables in HSQL DB" Watch "How to copy Oracle tables in HSQL DB" New topic

How to copy Oracle tables in HSQL DB

Aniruddh Joshi
Ranch Hand

Joined: Jul 29, 2008
Posts: 275

I want to create a local copy of some tables on my machine in HSQL DB.
Tried Exporting scripts using toad and running them on HSQL prompt but it does not recognize many keywords.
Am I trying something that's not feasible?
What is the easiest way to create a copy of the tables in HSQL DB?

"One of the best things you could do is to simplify a larger application into a smaller one by reducing its process and complexity - Fowler"
Bill Gorder

Joined: Mar 07, 2010
Posts: 1681

I don't think there is anything for free. You will just need to re-write the ddl. If you are looking at spending some money RazorSql advertises it will do this.

[How To Ask Questions][Read before you PM me]
subject: How to copy Oracle tables in HSQL DB