Performing Bulk Load of XML Data

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ted
    #1

    Performing Bulk Load of XML Data

    I found this quite interesting. However, it seems to assume I have a
    schema defined in an xsd or xdr file.

    I get a data feed that appears to be well formed XML, but there is no
    schema.

    Is it possible to bulk load XML data without a schema file being
    available? If not, is there a tool that will create a schema from a
    sample XML file?

    I have MS Visual Studo 2005, and so have the developer's edition of MS
    SQL Server 2005, if that matters.

    Please phrase your reply as if for someone who has not worked much
    with XML. While I have worked extensively with languages like FORTRAN
    and C++ for decades, I have successfully managed to avoid XML until
    now. :-( While I understand XML, I have no experience with XSL, and
    while I love number crunching, I hate parsing. So you understand that
    while not exactly a novice in developing applications, I am venturing
    into what is for me new territory.

    On a different note, while I have a developer's license for SQL
    Server, can my employer legally use SQL Server Express as a back end
    for an application I make for him? He, and an administrative aide,
    will be the only people using it. It is NOT something that will ever
    be distributed.

    Thanks.

    Ted
    Tags: None
    • Tom van Stiphout
      #2
      Re: Performing Bulk Load of XML Data

      On Mon, 14 Apr 2008 18:37:31 -0700 (PDT), Ted <r.ted.byers@ro gers.com>
      wrote:

      On your different note: Legal questions are best asked of lawyers, but
      the way I understand things the answer is Yes.
      -Tom.

      >I found this quite interesting. However, it seems to assume I have a
      >schema defined in an xsd or xdr file.
      >
      >I get a data feed that appears to be well formed XML, but there is no
      >schema.
      >
      >Is it possible to bulk load XML data without a schema file being
      >available? If not, is there a tool that will create a schema from a
      >sample XML file?
      >
      >I have MS Visual Studo 2005, and so have the developer's edition of MS
      >SQL Server 2005, if that matters.
      >
      >Please phrase your reply as if for someone who has not worked much
      >with XML. While I have worked extensively with languages like FORTRAN
      >and C++ for decades, I have successfully managed to avoid XML until
      >now. :-( While I understand XML, I have no experience with XSL, and
      >while I love number crunching, I hate parsing. So you understand that
      >while not exactly a novice in developing applications, I am venturing
      >into what is for me new territory.
      >
      >On a different note, while I have a developer's license for SQL
      >Server, can my employer legally use SQL Server Express as a back end
      >for an application I make for him? He, and an administrative aide,
      >will be the only people using it. It is NOT something that will ever
      >be distributed.
      >
      >Thanks.
      >
      >Ted

        Comment

        Previous template Next
        Working...