• To: "Li Yuejiong\(John\)" <john_li@m...>,<xml-dev@l...>
• Subject: RE: save XML into database
• From: "Michael Rys" <mrys@m...>
• Date: Fri, 28 Oct 2005 00:52:41 -0700
• Thread-index: AcW6c4dfu/j2I3DcRviVEVDgCkGvfAhGmC2AAAGDNLA=
• Thread-topic: save XML into database

You can load XML into most relational database systems now like SQL
Server 2005 (which was released yesterday, btw), Oracle 10 or even IBM
DB2 :-) or some of the native XML databases.

Since I am biased, I would recommend SQL Server 2005 (you can get a free
version of SQL Server 2005 Express on msdn.microsoft.com/sql). Loading
an XML file is a single statement:

INSERT INTO table(xmlcol) select x from OpenROWSET(BULK 'yourfile.xml',
SINGLE_BLOB) as T(x)

Or you can use bulkload facilities etc. The other databases have similar
ways to load the data.

Best regards
Michael (PM for XML Support in SQL Server 2005)
http://sqljunkies.com/weblog/mrys


> -----Original Message-----
> From: Li Yuejiong(John) [mailto:john_li@m...]
> Sent: Friday, October 28, 2005 12:08 AM
> To: xml-dev@l...
> Subject:  save XML into database
> 
> Hi,
> 
> I want to save XML file into database, eg SQL Server, Oracle or maybe
> Access. I am a newbie of database, so is there any guideline of such a
> task?
> 
> 
> Thanks,
> John
> 
> 
> -----------------------------------------------------------------
> 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: save XML into database
• Next by Date: Re: XML Schemas
• Previous by thread: Re: save XML into database
• Next by thread: RE: save XML into database
• Index(es):
  • Date
  • Thread