Re: Loading XML to SLQ Server
From: Bertan ARI [MSFT] (bertan_at_online.microsoft.com)
Date: 09/22/04
- Next message: James Edwards: "Re: SQLXML 3.0 - Migrating"
- Previous message: alocin: "Re: sqlxml, annotated schema and many-to-many relation"
- In reply to: SqlJunkies User: "Loading XML to SLQ Server"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 22 Sep 2004 00:00:30 -0700
A previous post to the newsgroup:
"In SQL Server 2000 you have two main options - using the OPENXML technology
or using the SQLXML BulkLoad technology. Choosing between these two options
is largely a matter of personal choice in terms of what technologies you
feel most comfortable with. OPENXML is a technology that runs in the server
while and requires a reasonable level of familiarity with T-SQL. SQLXML
BulkLoad runs on the client and requires no T-SQL but you need to generate
an Annotated XSD to determine the mapping between the XML and the database.
One other thing to consider is the size of the data being loaded. OPENXML
loads the entire XML into memory on the server so if you are loading large
amounts of data you may want to go with a BulkLoad solution.
You can get more information on OPENXML in SQL BOL or online at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_oa-oz_5c89.asp
SQLXML documentation is at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnanchor/html/anch_SQLXML.asp
or you can check out http://www.sqlxml.org/ for some extra info on these
technologies."
I should also add that if you want to develop your application by using
.Net, you may want to use Dataset as well. Dataset has also a drawback of
loading all data into memory similar to OpenXml.
-- Bertan ARI This posting is provided "AS IS" with no warranties, and confers no rights. "SqlJunkies User" <User@-NOSPAM-SqlJunkies.com> wrote in message news:OKM$bJGoEHA.4068@tk2msftngp13.phx.gbl... > Whats the best way to load XML into SQL Server.. > For example just a single XML file.. > thanks > > --- > Posted using Wimdows.net NntpNews Component - > > Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
- Next message: James Edwards: "Re: SQLXML 3.0 - Migrating"
- Previous message: alocin: "Re: sqlxml, annotated schema and many-to-many relation"
- In reply to: SqlJunkies User: "Loading XML to SLQ Server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
