[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

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

• From: "Mike Sharp" <msharp@l...>
• To: xml-dev@x...
• 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!

regards,
Mike Sharp




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

To:   xml-dev@x...
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.


Cheers,

Tom Passin









***************************************************************************
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/
***************************************************************************

• Prev by Date: Re: British Telecom owns Hyperlink?
• Next by Date: MSIE XSLT vs. XT XSLT
• Previous by thread: RE: SQL Schema to XML Schema generator [any out there?]
• Next by thread: RE: SQL Schema to XML Schema generator [any out there?]
• Index(es):
  • Date
  • Thread