xml-dev - Re: Generic XML export/import tool for relational databases

[Steve Muench <smuench@us.oracle.com>]

| Does anyone know of a general purpose tool 
| that will allow data to be exported from, 
| and imported into, a relational database?
| It would have to allow some form of mapping
| between XML entities/attributes and database tables/fields.

For Oracle databases, Oracle provides the XML SQL Utility
library to do bidirectional mapping. It takes a canonical
mapping approach that works for all supported built-in types
and user-defined object types. It leverages XSLT to 
capture mappings from custom to canonical mappings.

Info on it can be had at:

 http://technet.oracle.com/tech/xml

You might also check out Ron Bourret's work at:

http://xmlhack.com/read.php?item=620

Or the work being done by the Castor team at Exolab:

http://castor.exolab.org

______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
BC4J & XSQL Servlet Development Teams, Oracle Rep to XSL WG
Author "Building Oracle XML Applications", O'Reilly
http://www.oreilly.com/catalog/orxmlapp/