OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

 


 

   RE: [xml-dev] XML into SQL and out again

[ Lists Home | Date Index | Thread Index ]

If you are using SQL Server then you might be interested in the SQL Server's XML features. An overview is available at 
 
 http://msdn.microsoft.com/library/en-us/dnexxml/html/xml07162001.asp
 
or you can browse the page at 
 
http://msdn.microsoft.com/sqlxml/ 
 
for more details. 

________________________________

From: Neile Bermudes [mailto:Neile.Bermudes@ecb.co.uk]
Sent: Thu 3/27/2003 7:17 AM
To: xml-dev@lists.xml.org
Subject: [xml-dev] XML into SQL and out again



Hello all

 

I have been asked to undertake a project at work: we have a Directory booklet with all the contact details for staff in our organization, which we create in Quark. I would now like to create a SQL database with the same information, and which can be searchable using ASP scripts from our company Intranet. Obviously it would be absolutely crazy to update both Quark and SQL separately every time contact details change. 

 

What I would like to do: first, export all the information in Quark into a SQL database, having exactly the same information in both. Then, as details change, just update the database. Once a year, when we print out the Staff Directory booklet, I would like to then like to get the updated information into Quark so it can be printed. 

 

The way to export info from Quark into a useable format is by using their product, Avenue, which exports to XML. From XML, I can get the info into SQL. Then, when I need to update Quark, I export from SQL into XML and then back into Quark. 

 

My main question is can I get the XML data into SQL columns and fields, like regular SQL data? And once it's in their, can I query it/mess with it like normal data for other purposes, like accessing it on my Intranet via ASP? How is this XML data treated once in SQL??

 

Any info would be appreciated, even is just a pointer to some good resources/site/books etc

 

Thanks

 

Neile

--

 

Neile Bermudes

Network Support Analyst

England & Wales Cricket Board

020 74321241

 





 

News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS