Writing xml file from MS SQL

[Diez B. Roggisch]

Ros wrote:

> I am using pymssql for storing data into MS SQL. (I am using pymssql
> first time so dont know much about it)
> I wish to write/create XML file from database.
> There are few examples available for mysql but not much information
> about pymssql and MS SQL.
> 
> I have worked with cElementTree with SAX and I guess it can parse data
> in the most efficient manner if you compare it with other parsers. How
> can I use cElementTree to write xml file with the combination of
> pymssql(MS SQL) and pyxml.

1) read data from database
2) create XML-Nodes filled with this data
3) write XML-Nodes to disk
4) ....
5) Profit!

Diez