This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android 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: 1648
    
    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
Encrypted database with HSQL
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