Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
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 scrutinizing the Monastery: (6)
As of 2014-09-18 22:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (126 votes), past polls