RE: [xsl] extension to insert XML into a db

Subject: RE: [xsl] 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: [xsl] 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

Current Thread