Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: XML to sql server database

by pajout (Curate)
on Sep 24, 2009 at 10:32 UTC ( [id://797163]=note: print w/replies, xml ) Need Help??


in reply to XML to sql server database

I think two different issues appears in your question:

Firstly, how to connect the database. As previously said, DBI module and proper driver for your sql machine can support it.

Secondly, your question is about XML. I see many logical ways how to put XML document into sql tables. Consider that SQL data structures are not primarily designed for XML, therefore you can simply put XML text into one cell as a string, or you can design own tables and put XML into more structurally. Or, you can use some database-vendor xml-specific enhancement and put XML doc into it and use wide set of tools supported. It very depends what actions have to be performed against database-layered xml document(s).

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (7)
As of 2024-03-29 14:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found