• 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
Bartender
Posts: 4033
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: 2620
14
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)?
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!