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.

    Regards,
    Ros
     
    Ros, Mar 8, 2007
    #1
    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
     
    Diez B. Roggisch, Mar 8, 2007
    #2
    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.