XML in DataBase
- From: "prasad" <prasadckoranne@xxxxxxxxx>
- Date: 19 Mar 2006 21:18:24 -0800
We need to store an entire XML document intact (not breaking the
document
into relational data).
We have been attempting to submit the data into a text field within SQL
Server 2000 via an updategram, but the data will only send in under
4000
characters worth of data (and the XML file will be between 9K and 20K
in
size).
The question is, should we store the XML file inside a text field, or
is it
better to store the xml data as a file in the file system (and a link
within
the SQL database to the file). The XML file doesn't require parsing, or
modification.
If we store the data in the database, then we are having to deal with
the
issue of performance and also the fact we haven't been able to get a
large
xml file into the database successfully.
If we store the data in a file with a link in the database, then we
will be
extra concerned about potential problems if the file is inadvertently
deleted while the database entry still exists.
Any suggestions?
.
- Prev by Date: Re: Mapping two schema definitions to one column
- Next by Date: Re: Passing an Entire XQuery String as Variable
- Previous by thread: Mapping two schema definitions to one column
- Next by thread: Re: XML in DataBase
- Index(es):
Relevant Pages
|
