Yeah I used SDT long ago, Doug wrote some awesome stuff! But I need more than just printouts - I need to be able to store and retrieve table structures as we go. I also need it for more than VFP tables. Vendors can't/won't provide a data dictionary, and our in-house programmers didn't document their code.
Looks like I'll be rolling my own in my spare time. That being the case, work should begin sometime around June of 20-never. Lol On a happier note: GAME ON! NHL season opens tonight!!! Lou -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Johnson Sent: Thursday, October 07, 2010 9:41 AM To: [email protected] Subject: Re: Database documentation? On 10/07/2010 09:34 AM, Stephen Russell wrote: > On Thu, Oct 7, 2010 at 11:24 AM, Lou Syracuse<[email protected]> wrote: > >> Anybody know of a good (cheap) tool to handle database documentation? >> >> >> >> We have several VFP based systems developed in house, one large 3rd party >> VFP-based system (180+ tables), one system using "Advantage" (Sybase),. and >> soon SQL Server. And not a line of documentation or chart to be found. >> >> >> >> If I have to enter some/all of the information manually so be it - I just >> need something to help document what to find where, and I'd prefer something >> other than Excel. lol >> > -------------------------------------- > > I use to use Doug Hennings Data Dictionary product a longgggggg time ago. > > You could write your own to identify all tables and all columns to > respective DD tables. > > > I use Doug's Stonefield Database Toolkit which has the ability to print tables and fields, etc. I recently used it for exactly what you are doing. There is also a program called Versatools which does documentation as well as locating text in project files. Jeff --------------- Jeff Johnson [email protected] (623) 582-0323 www.san-dc.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/013601cb6642$40f67740$c2e365...@com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
