Generating XML schemas from an SQL database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

This is just me - 25 Oct 2003 18:03 GMT

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

Reply to this Message

Kirk Allen Evans [MVP] - 27 Oct 2003 02:22 GMT

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.

Signature

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

> Hi !
>
[quoted text clipped - 4 lines]
> best regards
> Terje

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...