• To: "Michael Champion" <michaelc.champion@g...>,<william.j.boxall@a...>
• Subject: RE: Large xml processing into SQL Server
• From: "Michael Rys" <mrys@m...>
• Date: Sat, 8 Jan 2005 22:36:42 -0800
• Cc: "XML Developers List" <xml-dev@l...>
• Thread-index: AcT0+PqaA4aT0K23SUi/xiyyNQXX1gBG8fqw
• Thread-topic: Large xml processing into SQL Server

Note that the SQLXML XML Bulkload object is based on a SAX parser. So
you should not have a problem with a file that size.

Best regards
Michael

> -----Original Message-----
> From: Michael Champion [mailto:michaelc.champion@g...]
> Sent: Friday, January 07, 2005 12:37 PM
> To: william.j.boxall@a...
> Cc: XML Developers List
> Subject: Re:  Large xml processing into SQL Server
> 
> On Fri, 7 Jan 2005 14:14:18 -0600, william.j.boxall@a...
> <william.j.boxall@a...> wrote:
> 
> > Thank you all who have offered to help!
> 
> Have you looked at
> http://www.awprofessional.com/articles/article.asp?p=102307 ?  It's a
> sample chapter" Using SQL Server's XML Support"  By Ken Henderson.
> from The Guru's Guide to SQL Server Architecture and Internals.
> (Addison Wesley Professional.) It discusses bulk loading.
> 
> Since your file seems to be structured into relatively simple records,
> can you just break up the file into smaller chunks?
> 
> -----------------------------------------------------------------
> The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
> initiative of OASIS <http://www.oasis-open.org>
> 
> The list archives are at http://lists.xml.org/archives/xml-dev/
> 
> To subscribe or unsubscribe from this list use the subscription
> manager: <http://www.oasis-open.org/mlmanage/index.php>

• Prev by Date: Re: So, what's new in the world of RELAX NG?
• Next by Date: Re: So, what's new in the world of RELAX NG?
• Previous by thread: RE: Large xml processing into SQL Server
• Next by thread: XML-Writer: requests?
• Index(es):
  • Date
  • Thread