Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within JDBC and Relational Databases Search Coderanch
Advance search Google search
Register / Login
book review grid granny thread boost polymorphism advertise on coderanch
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
book review grid advertise on coderanch thread boost meaningless drivel building better world book
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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

 
prabhu pandurangan
Ranch Hand
Posts: 147
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • 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
Posts: 4356
45
I like...
jQuery Eclipse IDE Java
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • 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.

[OCP 21 Professional Study Guide] [OCP 17 Complete Study Guide] [OCP 17 Practice Tests] [OCP 11 Complete Study Guide] [OCP 11 Programmer I] [OCP 11 Programmer II] [OCP 11 Practice Tests] [OCA 8] [OCP 8] [OCP 8 Practice Tests Book] [Blog]

 
Jan Cumps
Bartender
Posts: 2662
19
I like...
Netbeans IDE C++ Linux
posted 14 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Since Access is a file based database, can't you simply copy your database file(s)?

OCUP UML fundamental and ITIL foundation

 
Space pants. Tiny ad:
Clean our rivers and oceans from home
https://www.kickstarter.com/projects/paulwheaton/willow-feeders
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...