Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

Re: I have a generalized "from XML to SQL" chore... best way?

by blahblahblah (Priest)
on Feb 29, 2008 at 00:46 UTC ( #671066=note: print w/ replies, xml ) Need Help??


in reply to I have a generalized "from XML to SQL" chore... best way?

Interesting problem. Building a database from XML data feed recently asked a similar question. It mentioned two modules, DBIx::XML::DataLoader and XML::RDB.

It also might be interesting to see whether the db itself, or other external tools, can do part of the job for you. For example, MS SQL Server's XML Bulk Load Component.

Joe


Comment on Re: I have a generalized "from XML to SQL" chore... best way?
Re^2: I have a generalized "from XML to SQL" chore... best way?
by sundialsvc4 (Abbot) on Feb 29, 2008 at 16:57 UTC

    Hmmm... that term sounds vaguely familiar.   What does “MS” stand for, again?

    ;-)

    From the look of things, it seems like XML::XPath might do such a good job of ripping into the XML structure that a few short scripts might just do it for us.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://671066]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (7)
As of 2014-10-21 06:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (97 votes), past polls