http://qs321.pair.com?node_id=671066


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?

Replies are listed 'Best First'.
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.