Re: Store XML in database - newbie question
From: Michael Rys [MSFT] (mrys_at_online.microsoft.com)
Date: 09/19/04
- Previous message: Slide-O-Mix: "Re: Come on Microsoft guys!!(Or anyone)This has been posted before"
- In reply to: BobM: "RE: Store XML in database - newbie question"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 19 Sep 2004 00:43:14 -0700
In SQL Server 2000, you can:
1. shred it into relations easily either using a mapping schema or OpenXML.
Works best for structured data.
2. Store it as IMAGE or NTEXT (preserves the original form). Need to check
for XML well-formedness on midtier before.
In SQL Server 2005, you can use an XML datatype.
Best regards
Michael
"BobM" <BobM@discussions.microsoft.com> wrote in message
news:BC7D0533-4214-44D7-A401-97B7B696D25C@microsoft.com...
> If you are using Oracle you can define a column as an XMLType this will
> allow
> you store and retrieve the XML as a column. In order to utilise this it is
> necessary to download an addition ODP toolkit from Oracle to access it in
> .Net. There is also the possibilty of storing the XML as part of the
> relational database within Oracle although I haven't used that option yet.
>
> "JezB" wrote:
>
>> I'm not sure which group to post this in, so forgive me if I post to a
>> few,
>> hoping that someone can point me in the right direction.
>>
>> In a .NET project (probably ASP.NET but could also be rich client), I
>> want
>> to save some XML data to a database (sql-server but could also be
>> Oracle).
>> How can I do this ? I certainly cant see XmlDocument as a type available
>> for
>> columns in a database table, but perhaps it could be converted to/from a
>> Binary or Text column ?
>>
>>
>>
- Previous message: Slide-O-Mix: "Re: Come on Microsoft guys!!(Or anyone)This has been posted before"
- In reply to: BobM: "RE: Store XML in database - newbie question"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
