Need help!

[kamna jain <ka...@gmail.com>]

 Hi,
Can you please tell me how to export MS Access database to a Derby database
in Eclipse envt.

Thanks,
-- 
Kamna Jain

Re: Need help!

[ho...@pacbell.net]

----- Original Message ---- 
From: kamna jain 
To: derby-user@db.apache.org 
Sent: Friday, June 9, 2006 9:50:14 AM 
Subject: Need help! 




Hi, 
Can you please tell me how to export MS Access database to a Derby database in Eclipse envt. 

Thanks, 
-- 
Kamna Jain 
---------------------------------------------------------------
 
Hi Kamna,
 
The Web Tools Project (WTP) set of Eclipse tools allows you to import and export data sets into a Derby database and is available for download at: http://www.eclipse.org/webtools/
 
I looked around a little bit and found this plug-in for use with MS Access databases, although I have
never tried it:
 
eva/3 Application Builder:
 
http://www.eclipseplugincentral.com/Web_Links-index-req-viewlink-cid-204.html
 
It appears to support import and export functions as well although I can't tell if it has a DDL
generation tool.
 
The worst case you would have to manually create the tables in Derby, export the data from MS Access
using the eva/3 Application Builder and then import the data into Derby using the WTP set of tools.
 
Good luck!
 
Susan