Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to get the DB dump from MS ACCESS using java code?

 
prabhu pandurangan
Ranch Hand
Posts: 147
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I need to get the database dump from Ms Access database, using java standalone application, using Java Runtime exec. process.

We have an functionality in Mysql 'mysqldump' but i do not know we have a similar kind of function in MS Access.

Kindly help me out in this. It would be better if i can get some sample code.

Regards,
Prabhu
 
Scott Selikoff
author
Saloon Keeper
Posts: 4028
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
In Access, you can export the tables to CSV. In Java, though, you would have to query each table and pull each record. The Meta Data JDBC classes can assist in automating this, though.
 
Jan Cumps
Bartender
Posts: 2602
13
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since Access is a file based database, can't you simply copy your database file(s)?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic