File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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: 1682

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]
I agree. Here's the link:
subject: How to copy Oracle tables in HSQL DB
It's not a secret anymore!