[XML-DEV Mailing List Archive Home]
[Reply To This Message]
XML into SQL and out again
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
Network Support Analyst
England & Wales Cricket
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
Stylus Studio has published XML-DEV in RSS and ATOM formats,
enabling users to easily subcribe to the list from their preferred news reader application.
Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website.
they were not included by the author in the initial post. To view the content without the Sponsor Links please