Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
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 (Monsignor) 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 chanting in the Monastery: (8)
As of 2014-07-24 00:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite superfluous repetitious redundant duplicative phrase is:









    Results (155 votes), past polls