OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



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

[ Lists Home | Date Index | Thread Index ]
  • From: "Mike Sharp" <msharp@lante.com>
  • To: xml-dev@xml.org
  • Date: Mon, 26 Jun 2000 11:43:10 -0700

Yes, this is how we do it here.  On one project, at least, we're using a code
generator for the object layer that gets the ERD using ODBC (just like the one
produced by ErWin), and generates all the base object classes, including FK
relationships.  We "turn off" those that we're not interested in, and how it
does it, I have no idea (I'm just a lowly UI developer)!  But it works well as a
starting point!

Mike Sharp

tpassin@home.com on 06/26/2000 07:54:43 AM

To:   xml-dev@xml.org
cc:    (bcc: Mike Sharp/Lante)

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

Len Bullard wrote -

> How would it get foreign key information?  While
> one does declare primary keys, foreign keys aren't
> declared AFAICT in many schema design tools.  One
> does usually find a description field and if the
> designer does a professional job, they may include
> the role of the field value in the overall design,
> eg, a key to a table named nnnnn.

What can I say? ERWin gets the schema, including foreign keys, from the
database, using ODBC.  At least, it can do it for the databases I use the
most.  Of course, if the database doesn't really use foreign keys, like
xBase, you're out of luck, that's true.


Tom Passin

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/


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS