Generating XML schemas from an SQL database -- dotnet xml

This is just me
10/25/2003 7:03:10 PM

Hi !

Do anyone know of a tool for generating XML schemas from an SQL database
without using the Visual Studio .net ? The reason is to try to automate
the process when changes occur to the SQL database.

best regards
Terje

Kirk Allen Evans [MVP]
10/26/2003 5:22:27 PM

You can use a FOR XML select statement, using XMLDATA as a flag on the
statement. This will create an XDR schema for the XML select statement you
are generating. You can then use the XDR schema as an input to XSD.EXE and
generate the XML Schema.

--
Kirk Allen Evans
Microsoft MVP, ASP.NET
www.xmlandasp.net
Read my web log at http://weblogs.asp.net/kaevans

[quoted text, click to view]

dotnet xml : Generating XML schemas from an SQL database