Friday, 30 August 2013

query/shred large xml document into sql server

query/shred large xml document into sql server

I'm looking to query an xml file that's in excess of 80GB (and insert the
results into a pre-existing db). This prevents me from simply declaring it
as an xml variable and using openrowset. I am NOT looking to use a CLR and
would prefer an entirely TSQL approach if possible (looking to do this on
SQL Server 2012/Windows Server 2008)
With the 2Gb limit on the XML datatype, I realize the obvious approach is
to split the file into say 1GB pieces. However, it would simply be too
messy to be worthwhile (Elements in the document are of varying sizes and
not all elements have the same sub-elements. Only looking to keep some
common elements though).
Anyone have a suggestion?

No comments:

Post a Comment