[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: 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>
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|