Great XML

[kemal]

The new XML is great, no parsing etc ....
But now I get into this new problem :
We have decided to work with couple of counterpart on a new project.
They already have their DTD already defined and some sample of XML.
Is their a way to create my SQL Server database out of that information or
do I have to do it manually.

I am looking at the same problem to create the ASP forms for those XML.

Thanks
Kemal

[Drew Minkin]

Kemal,

The native technology for SQL Server 2000's XML support is a document
schema as opposed to using a DTD.

However, there is a tool available from http://msdn.microosft.com/sqlserver
called XML View Mapper that will kill two birds with one stone: It not
only will convert your DTD into a schema, but you can then use a GUI to map
the tables and columns to the nodes of information in your document. With
XSD just around the corner, I suggest you look into schemas as opposed to
the DTD specification for future document validation strategies

In creating forms for XML documents, I suggest you take a look at XSLT.
While it is not GUI based, it is a very clean and powerful adjunct to
tradition ASP based HTML generation by building a lot of the programming
logic and data nesting into an XML document that is use to transform the
source document into final HTML code. The tutorial available at
http://msdn.microosft.com/xml is very good at bringing you up to speed
quickly.

I hope this helps,

Drew Minkin, MCDBA, MCSD, MCSE
SQL Support Professional, Microsoft Corporation
email: dmi...@microsoft.com