Alright I am way new to XML but Not SQL. The stuff I am trying to do requires me to use XML as my Data source. Problem is everything is in a SQL data base. The editors are built to update everything in the SQL data base.
Is there a way to have SQL update the XML files.

Being new I could use a little direction on this one.
Thanks,

I worked on a project a year or so ago that used xml to transfer data between an Oracle DB and AS400 DB.

In theory, you can use triggers in sql to do the same thing, you just set the triggers (or of course stored procedures) to send the data to an xml source when the sql db is amended.

You will of course still need to keep you sql online. Can you not plan a migration of all sql data to xml?

They must havea pretty good reason to want to do this....I take it they are going to allow access to the data on other db platforms?

ANyway, you will find info on the MSDN site at MS for info on sql to xml.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting