Exporting XML to a file

Is there a way to get BCP or a sql store procedure to export my database to a
XML file ?
You may use FOR XML queries to export you all db as XML.
"rseedle" <rseedle@.discussions.microsoft.com> wrote in message
news:35182A41-7226-4D91-84B7-576301CBB400@.microsoft.com...
> Is there a way to get BCP or a sql store procedure to export my database
> to a
> XML file ?
|||I guess what I really want to know is, how do I get the results of the select
... for XML to a file. Getting it to display on the screen is nice but I
really needs it to be in a file.
Randy
"Bertan ARI [MSFT]" wrote:

> You may use FOR XML queries to export you all db as XML.
>
> "rseedle" <rseedle@.discussions.microsoft.com> wrote in message
> news:35182A41-7226-4D91-84B7-576301CBB400@.microsoft.com...
>
>
|||In addition, when I run the query:
select * from Users for xml auto
or
select * from Users for xml raw
Query analyzer truncates the text that gets displayed. So if I do tell it to
save it to a file in Query Analyzer the XML data is truncated.
"rseedle" wrote:
[vbcol=seagreen]
> I guess what I really want to know is, how do I get the results of the select
> ... for XML to a file. Getting it to display on the screen is nice but I
> really needs it to be in a file.
> Randy
> "Bertan ARI [MSFT]" wrote:
|||You have to write a small APP that will execute your query and store the
results in a file stream.
"rseedle" <rseedle@.discussions.microsoft.com> wrote in message
news:8A27F4A1-0D39-47E0-A4CE-E77EC2ECED58@.microsoft.com...[vbcol=seagreen]
> In addition, when I run the query:
> select * from Users for xml auto
> or
> select * from Users for xml raw
> Query analyzer truncates the text that gets displayed. So if I do tell it
> to
> save it to a file in Query Analyzer the XML data is truncated.
>
> "rseedle" wrote: