[Home] [By Thread] [By Date] [Recent Entries]
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/ ***************************************************************************
|

Cart



