Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    Glasgow, Scotland
    Posts
    107

    Unanswered: Export Data to XML Format

    Hi,

    What's the best way to export data from SQL Server to XML format. I've taken over a VB application written to carry out this task but it seems more complicated than it needs to be. Is it possible to just miss out VB and use say a DTS program instead??

    I have been given a schema(XSD) file and as far as I'm aware any xml has to be formatted according to this schema.

    Thanks
    Matt

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447
    You shouldn't re-invent XML by programming it; there are ton's of documentation how to use default functionality, see for example (including code)
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  3. #3
    Join Date
    Mar 2004
    Location
    Glasgow, Scotland
    Posts
    107

    Thumbs up

    Thanks for the link. The VB program seems to be using ADO and DOM to generate the XML doc so think I will just leave it at that. The only improvement that I think could be made is to move the formatting of the XML doc to an XSLT stylesheet - at the moment the formatting is hard coded using VB....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •