Which way will be easy to load XML data to SQL Server 2000
1. OPENXML
2. BULK LOAD
3. UpdateGRAM.
Thanks
This depends a lot on how much data you have to load and how complex the
schema you're loading it into is. Updategrams are not really suited to
loading large quantities of XML. Bulk Load is good for loading a lot of
data and doesn't require a lot of coding but it does require a mapping
schema to map the XML schema to the database schema. OpenXML is pretty easy
to code and doesn't require a mapping schema but it has a tendency to run
out of memory if you try to load very large documents.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"MK" <anonymous@.discussions.microsoft.com> wrote in message
news:20c8d01c45a00$53af6540$a301280a@.phx.gbl...
> Which way will be easy to load XML data to SQL Server 2000
> 1. OPENXML
> 2. BULK LOAD
> 3. UpdateGRAM.
> Thanks
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment