[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: tpassin@h...
• To: <xml-dev@x...>
• Date: Fri, 23 Jun 2000 21:57:16 -0400

Len Bullard wrote -

> By the way, just as an addendum.  When you use
> tools that enable you to generate schemas from
> say, relational dbs, tools that reverse engineer
> instances can only get you so far.  For example,
> XML-Spy has a great feature for doing this using
> ODBC to connect and get you the table layouts.
> However, if a table has no data, it can't, of course,
> generate that so it doesn't kick out an instance.
> So when you try to generate a schema, you are stuck.
>
> 1.  Use a test database with sufficient data to
> generate the instance.  Otherwise, it can't
> do anything for that table.
>
 Not necessarily.  I haven't tried it with Spy, but ODBC has the ability to
get table definitions from those databases that support them. And even dBase
tables carry schema information within themselves.  I **think** it can also
get foreign key information as well, but I'm not as positive on this.

Whether a particular product uses the capability, though, that's another
thing.

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

• References:
  • RE: SQL Schema to XML Schema generator [any out there?]
    • From: "Bullard, Claude L (Len)" <clbullar@i...>

• Prev by Date: Re: XML Schema generation questions [was SQL schema to XML schema...]
• Next by Date: Re: Schema question
• 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