[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] XML Schema generation questions [was SQL schema to XML schema...]
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 [expletive deleted] 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@s... [mailto:johns@s...] Sent: Thursday, June 22, 2000 5:36 PM To: xml-dev@x... 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@x... [mailto:owner-xml-dev@x...]On Behalf Of Mike Sharp Sent: Thursday, June 22, 2000 1:22 PM To: xml-dev@x... 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@w...> on 06/22/2000 07:10:01 AM To: "XML Devlist (E-mail)" <xml-dev@x...> 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@x...&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@x...&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@x...&BODY=unsubscribe%20xml-dev List archives are available at http://xml.org/archives/xml-dev/ ***************************************************************************
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|