Web lists-archives.com

Re: Create Schema and repeatable import of XML

You can have a look at XMLPipeDB.



On 03/09, Sayth Renshaw wrote:
> Hi
> Hoping someone can help me work some information or direction to a good
> resource for using XML with Mysql.
> Specifically I have a complex XML file,  I would like to create a schema in
> MYSQL based on it (I have XSD as well) and be able to upload new xml data
> into the database as it's released to me.
> I cannot find a good way to achieve this, currently I am trying to use
> mysql for excel and map via excel into mysql. The data format is complex
> and a bit beyond scope of excel.
> Are there good resources that how to work with XML?
> Google searches don't show much but confusion and referral to expensive
> software such as XMLspy. If xml was supposed to be a universal format why
> is it so hard to work with.
> Sayth.

Attachment: pgpsYe_YW91qA.pgp
Description: PGP signature