[
Lists Home |
Date Index |
Thread Index
]
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@macrosynergy.com]
> Sent: Friday, October 28, 2005 12:08 AM
> To: xml-dev@lists.xml.org
> Subject: [xml-dev] 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>
|
