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

Re: Performing Bulk Load of XML Data

On Mon, 14 Apr 2008 18:37:31 -0700 (PDT), Ted
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