Selvakumar has asked for the wisdom of the Perl Monks concerning the following question:

Hi All,
I have a xml file created form XML schema. I want to move all the xml data to sql server database.
i am bit confused to use the module which support to connect the sql server databse and i need to update the xml data to that database.
Can anybody suggest me the module to connect and update/modify records in sql server database.

Replies are listed 'Best First'.
Re: XML to sql server database
by Anonymous Monk on Sep 19, 2009 at 06:43 UTC
Re: XML to sql server database
by Sewi (Friar) on Sep 19, 2009 at 13:03 UTC
Re: XML to sql server database
by pajout (Curate) on Sep 24, 2009 at 10:32 UTC
    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).