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 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 Murach's Java Servlets and JSP this week in the Servlets 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
Author

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?


Anrd
"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
Bartender

Joined: Mar 07, 2010
Posts: 1646
    
    7

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: http://aspose.com/file-tools
 
subject: How to copy Oracle tables in HSQL DB
 
Similar Threads
O'Reilly's Enterprise JavaBeans 3.0 for SCBCD
need info about hsql db
Embedding MySQL Database in Java Application
Web service Response to DOM
Encrypted database with HSQL