XML to sql server database

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.

Comment on XML to 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
DBI, DBI::FAQ	[reply]
Re: XML to sql server database by Sewi (Friar) on Sep 19, 2009 at 13:03 UTC
Your didn't say anything about the SQL-server you're going to connect. There are some DBD:: - modules on CPAN for many DB servers. You use them via the DBI module usually. For Sybase SQL and Microsoft SQL, use DBD::Sybase. Try Padre - the free Perl IDE	[reply]
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).	[reply]