RE: Description of Databases

["Jason Deal" <jason -at- mitratech -dot- com>]

I, too, am investigating tools to document database schemas, and I have hit
a wall.  The problem is that the developers are telling me that they
absolutely need column-to-column relationship indicators to indicate foreign
key/primary key relationships.  Visio's Reverse Engineer Wizard does not do
this; it indicates foreign keys and primary keys, but the table relation
arrows go table-to-table, not column-to-column.
I've also tried ERWin (same problem, it seems, though I did not have time to
really play with it to see what it could do) and Access (saved the database
in SQL Server and brought it into Access, it shows column-to-column
relationships, but none of the other nifty stuff that Visio does, like
datatypes, size, and required fields).
Any suggestions?


^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

A landmark hotel, one of America's most beautiful cities, and 
three and a half days of immersion in the state of the art:
IPCC 01, Oct. 24-27 in Santa Fe.  http://ieeepcs.org/2001/

  +++  Miramo -- Database/XML publishing automation.  See us at  +++
  +++  Seybold SFO, Sept. 25-27, in the Adobe Partners Pavilion  +++
  +++ More info: http://www.axialinfo.com  http://www.miramo.com +++

---
You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot-  Visit 
http://www.raycomm.com/techwhirl/ for more resources and info.