xml-dev - XML Schema generation questions [was SQL schema to XML schema...]

[Bob DeRemer <Bob.Deremer@wonderware.com>]

Thanks to everyone for their suggestions.  It turned out I had the solution
right under my nose.  I had just downloaded and installed XML Authority 2
days ago.  This allowed me to suck in table schemas from an ODBC DSN.  The
one interesting aspect is whether the columns should be Attributes or
Elements.  I've generated "BizTalk" compatible schemas for each type (i.e.
element-based and attribute-based).  I'm not sure yet, which approach is
best.

Being fairly new to XML (i.e. 3 months), I'm curious if others have done
this before.  If so, what they have learned along the way.  My gut instinct
is to keep all columns as attributes, and each table is an element.

If anyone has any suggestions, they would be greatly appreciated.

Thanks again,
Bob

-----Original Message-----
From: johns@syscore.com [mailto:johns@syscore.com]
Sent: Thursday, June 22, 2000 5:36 PM
To: xml-dev@xml.org
Subject: RE: SQL Schema to XML Schema generator [any out there?]


The BizTalk technology preview (something between alpha and beta in other
words) has two products: the Editor and the Mapper. The Editor generates the
schema - but this is an XDR schema, not a DTD or W3C XML Schema. The Mapper
will take two schemas and allow you to use graphical gestures (including
Functoids...) to map from one to the other. The Mapper will generate an XSLT
document - but again this is MS XSL not the W3C version.

Yours,
John F Schlesinger
SysCore Solutions
212 619 5200 x 219
917 886 5895 Mobile

-----Original Message-----
From: owner-xml-dev@xml.org [mailto:owner-xml-dev@xml.org]On Behalf Of
Mike Sharp
Sent: Thursday, June 22, 2000 1:22 PM
To: xml-dev@xml.org
Subject: Re: SQL Schema to XML Schema generator [any out there?]






Download Microsoft's Biztalk Server Technology Preview.  It has a tool
called
the Mapper, that among other things, can generate a schema from an instance
of
XML.  Then you can tweak it to fit your needs. It also provides a graphical
way
to map between schemas or XML documents.  I've only played with it for a
little
bit, but several associates have used the tool, and have good things to say
about it.

http://www.microsoft.com/biztalkserver/techres/techpreview.asp

The caveat is that it only runs on Windows 2000.

Regards,
Mike Sharp

Before you criticize someone, you should walk a mile in their shoes. That
way,
when you criticize them, you're a mile away and you have their shoes.    --
KPIG



Bob DeRemer <Bob.Deremer@wonderware.com> on 06/22/2000 07:10:01 AM

To:   "XML Devlist (E-mail)" <xml-dev@xml.org>
cc:    (bcc: Mike Sharp/Lante)

Subject:  SQL Schema to XML Schema generator [any out there?]



I know there are some tools that take SQL Schema and generate XML DTDs.
Does anyone know of a tool out there that generates an XML Schema?  I know
the schema stuff is not finalized yet, but that's OK for what I'm looking
for.  If there is something in Beta, I'd really like to look at it.  I want
to bootstrap an analysis project that needs to create an XML Schema [in the
MS environment, so I can leverage MSXML] for a SQL Server DB.  I'm trying to
avoid typing it all by hand.

Thanks in advance for the info,
Bob









..................................
http://www.lante.com



***************************************************************************
This is xml-dev, the mailing list for XML developers.
To unsubscribe, mailto:majordomo@xml.org&BODY=unsubscribe%20xml-dev
List archives are available at http://xml.org/archives/xml-dev/
***************************************************************************


***************************************************************************
This is xml-dev, the mailing list for XML developers.
To unsubscribe, mailto:majordomo@xml.org&BODY=unsubscribe%20xml-dev
List archives are available at http://xml.org/archives/xml-dev/
***************************************************************************

***************************************************************************
This is xml-dev, the mailing list for XML developers.
To unsubscribe, mailto:majordomo@xml.org&BODY=unsubscribe%20xml-dev
List archives are available at http://xml.org/archives/xml-dev/
***************************************************************************