Subject: RE: extension to insert XML into a db
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Mon, 21 Jan 2008 17:21:13 -0000
|
You could combine Saxon's sql:insert() with saxon:serialize() - first
serialize the XML into lexical markup, then insert it into the database as a
string.
Michael Kay
http://www.saxonica.com/
> -----Original Message-----
> From: Mario Madunic [mailto:hajduk@xxxxxxxx]
> Sent: 21 January 2008 17:05
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: extension to insert XML into a db
>
> I was wondering if there is an extension that can insert XML
> into a db. I know of the SQL extension that comes with Saxon
> but it only inserts strings and not the elements. I've been
> creating CSV's and then using ANT with BCP to get content
> that retains elements into SQLServer. It just seems to be the
> long route.
>
> Marijan (Mario) Madunic
|