Writing xml file from MS SQL

Discussion in 'Python' started by Ros, Mar 8, 2007.

  1. Ros

    Ros Guest

    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.

    Ros, Mar 8, 2007
    1. Advertisements

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

    Diez B. Roggisch, Mar 8, 2007
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.