Database Schema Export as XML

I am trying to export the schema of an existing SQL Server Database to
an XSD File so it can be then used in an XML Dataset for reporting
purposes in Visual Studio .NET.
If there is a way this can be done any help would be appreciated.
Many Thanks
Stuart
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Hi Stuart
(just posted something myself and noticed yours...)
can you select from each table/view/etc. using the 'for xml auto
(,whatever)' and save the output to a file?
(I do this all the time from MS Access as a passthru query to SQL Server,
which doesn't do the 255 char truncating like SQL Server does. Next I either
copy and paste into a file, save as, etc.)
lastly, there's an XSD Interference download and online utility (either on
gotdotnet.com or asp.net that'll let you process the file to generate your
XSD). its rough, but the other approach I could recommend is considerably
more difficult (would have to yank big chunks of a 'database clone' sproc I
have to get it down to something usable.)
Rob
"Stuart Ferguson" wrote:

> I am trying to export the schema of an existing SQL Server Database to
> an XSD File so it can be then used in an XML Dataset for reporting
> purposes in Visual Studio .NET.
> If there is a way this can be done any help would be appreciated.
> Many Thanks
> Stuart
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>