JAXB seems quite inappropriate for this: you want a generic 
XML format that can capture any table structure, not one that's 
schema-specific.
 
I thought all the significant relational databases had such 
utilities nowadays, so my answer would be to look first in the documentation of 
your specific database product.
 
Michael Kay
http://www.saxonica.com/


  
  
  From: VenuBabu 
  [mailto:venubabu@c...] 
Sent: 02 August 2005 
  10:01
To: xml-dev@l...
Subject: [xml-dev] 
  DataBase to XML


  
  
  Can any one suggest 
  what is the best of archiving data base records to XML file? I want to archive 
  the database records into XML file and later point of time I have to retrieve 
  and store those records from XML file into Database. 
  <o:p></o:p>
  <o:p> </o:p>
  I am 
  planning to use JAXB as JAXB is parser independent. Is there any other 
  efficient and easy way doing this? My priority is efficiency. 
  <o:p></o:p>
  <o:p> </o:p>
  Please 
  comment on this.<o:p></o:p>
  
  with 
  regards,<o:p></o:p>
  VenuBabu<o:p></o:p>
  CrimsonLogic 
  India Pvt Ltd 
formerly 
  known as SNS Software Labs Pvt Ltd
(a 
  subsidiary of CrimsonLogic Pte Ltd) 
  
#124, 
  6th Floor, Surya Chambers,<st1:address 
  style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"><st1:Street><st1:address><st1:Street>Airport 
  Road</st1:Street></st1:Street>, 
  
<st1:City><st1:City>Bangalore</st1:City></st1:address></st1:City></st1:address> 
  - 560 017, 
  <st1:country-region><st1:place><st1:country-region><st1:place>INDIA</st1:place></st1:country-region></st1:place></st1:country-region>
Main 
  Tel: +91 80 51289999, 51169001, 51169002, 2522 2887 /8 /9  Extn: 1161 
  Main Fax: +91 80 25222 884<o:p></o:p>
  <st1:City><st1:place><st1:City><st1:place>Mobile</st1:place></st1:City></st1:place></st1:City> 
  : 98860 59347<o:p></o:p>
  <o:p> </o:p>