Export data as XML

I am looking for a way to export data out of the SQL 2005 relational
database that is cleaner than using FOR XML query statements. I would
like to have a sort of mapping/xsd file that can be referenced when
executing the query that will provide proper mapping. Please let me
know if anything like this exists. ThanksTake a look at annotated schemas and XPath queries against it in the SQLXML
component that comes with the client tools of SQL Server 2000/2005.
Best regards
Michael
"Adi" <adisaric@.hotmail.com> wrote in message
news:1169773291.027460.105500@.v33g2000cwv.googlegroups.com...
>I am looking for a way to export data out of the SQL 2005 relational
> database that is cleaner than using FOR XML query statements. I would
> like to have a sort of mapping/xsd file that can be referenced when
> executing the query that will provide proper mapping. Please let me
> know if anything like this exists. Thanks
>|||Thanks Michael. I have looked into the annotated XML schema and it
seems relatively straightforward. My question is once I have created
the schema where do I store it? Also how do I execute exports and
imports against it? Thanks,
Adi
On Jan 25, 7:34 pm, "Michael Rys [MSFT]" <m...@.online.microsoft.com>
wrote:
> Take a look at annotated schemas and XPath queries against it in the SQLXM
L
> component that comes with the client tools of SQL Server 2000/2005.
> Best regards
> Michael
> "Adi" <adisa...@.hotmail.com> wrote in messagenews:1169773291.027460.105500
@.v33g2000cwv.googlegroups.com...
>
>|||The annotated schema is stored in a file... you will use the SQLXML
functionalities to to import into the database (XML Bulkload) or XPath
against annotated schema to extract.
Best regards
Michael
"Adi" <adisaric@.hotmail.com> wrote in message
news:1169834519.754165.50200@.v45g2000cwv.googlegroups.com...
> Thanks Michael. I have looked into the annotated XML schema and it
> seems relatively straightforward. My question is once I have created
> the schema where do I store it? Also how do I execute exports and
> imports against it? Thanks,
> Adi
>
> On Jan 25, 7:34 pm, "Michael Rys [MSFT]" <m...@.online.microsoft.com>
> wrote:
>