The new version of Visio that comes with Visual Studio .Net Enterprise Edition (what a mouthful) will do this and allow you to apply schema changes back to the database if you so wish.
It's pretty nice although it had some difficulty when we pointed it at our Oracle database and it refused to apply some changes citing some arcane relationship rules (wouldn't allow multiple foreign keys between two tables). -----Original Message----- From: Garza, Jeff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 6:49 PM To: CF-Talk Subject: RE: reverse engineering database structure I think I remember being able to do this with Visio 2000 Enterprise version. You can basically point it at a datasource and it will determine the database structure and diagram it out... I'm not sure if the newer versions also have this capability. HTH, Jeff Garza -----Original Message----- From: Douglas Jordon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 4:32 PM To: CF-Talk Subject: reverse engineering database structure We're building a site for a company that uses a very complex inventory and accounting system that's based on SQL Server. We'd like to use only a few fields from the database maybe a dozen or so to display some items on the web. There are a lot of tables, a 100 or so. There aren't very many relationships; a table might have four foreign keys but only one realtionship. Lots of SPs and Views. There is no diagram. How should I go about understanding this structure? Remember, I only need a few fields. Reading the MCSE book, it looked as if maybe a trace would be the way to go. As always, all suggestions are appreciated. TIA, Doug Jordon ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists