Writing xml file from MS SQL

[Ros]

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.

If you know any links, examples then please post them.

Regards,
Ros

 

[Diez B. Roggisch]

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