Hi,
I am working on a
project where we have to define database tables and data in XML, have it
validated by an XML Schema and have it loaded into the database. We are
using our EJBs to load the data into the database so I am not so concerned with
that. What I am concerned with is generating a correct XML Schema from the
Database tables.
Are there any
tools/utilities that I can use to generate an XML Document, XML Schema or
both from my Postgres Database?
Reason I ask is that
if we can generate the XML Schema automatically from our database schema it will
mean that we can have our XML validation rules driven from our database schema.
It would also mean that once the database tables change we can change the XML
Schema very easily rather then having to manually update the XML schema by
hand.
Any information on
Database TO XML/XML Schema and XML to Database Utilities would be very useful. I
have already used the utilities at http://www.hitsw.com/xml_utilites/index.html.
Also, any utilities suggested must be under a GPL license.
I have looked
through the archives and have not found any utility, but did find a thread
talking about the creation of an XML utility like the one that I am looking
for.
Any help much
appreciated.
thanks,
Richie.
Richie.
