Steve, Where were you this morning? ;)
Here is a copy of what I sent Bernie Lis this morning: Marnie Moore gave a presentation at the 1999 Developers' Conference entitled "How to Reverse Engineer a FoxPro Schema." This technique uses Visio Professional to diagram the schema including the relationships. I have used this on recent projects and it works well on any database with an ODBC driver. For a R:Base 4.5++ database I had to autoconvert to 6.5++, and do the analysis there. Marnie's notes in the '99 conference notebook are very complete although Visio has brought out new versions since 1999. Visio Pro you can find at your CompUSA. Visio was bought out by Micrsoft a couple of years ago. If I remember right it costs over $200. Be sure to get the Professional Version because the other versions don't do database analysis. It is a very useful tool. I've used it on several old R:Base databases by updating them to a version of R:Base that does ODBC temporarily just to get the schema diagram. I've had less luck analyzing an Access database as I couldn't seem to get the relationships. That was probably because the Access 2000 database was newer than my copy of Visio (5.0c from 1998) that I am using. I'll have to reinstall my Visio 2000 and see if I can get it to work better this time. Dave Billing Tall Tree Business Solutions ----- Original Message ----- From: "Stephen Markson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 3:10 PM Subject: RE: ERWin > > Sorry, ERD = Entity Relation Diagram, a standard means of graphically > representing a relational database. > > ERWin is a (great) product, now owned by Computer Associates, that let's > you develop and manage ERDs. (Download fully functional eval at > http://ca.com/registration/erwin_registration.htm ). It can reverse > engineer an ERD from an existing database as long as there is an ODBC > driver for the database. > > Stephen Markson > ForenSys The Forensic Systems Group > www.ForensicSystemsGroup.com > 416 482 2140 > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > On > > Behalf Of Troy Sosamon > > Sent: April 25, 2002 4:52 PM > > To: [EMAIL PROTECTED] > > Subject: RE: ERWin > > > > What is ERWin, and what is a graphical ERD? > > > > ===== Original Message from [EMAIL PROTECTED] at 4/25/02 12:41 pm > > >Thanks in advance for anyone's help with this one: > > > > > >Can an RBase database be "Reverse Engineered" with ERWin? > > > > > >Is there something else out there that will generate a graphical ERD > > >from an RBase DB? > > > > > > > > >Stephen Markson > > >ForenSys The Forensic Systems Group > > >www.ForensicSystemsGroup.com > > >416 482 2140 > > > > > > > > >================================================ > > >TO SEE MESSAGE POSTING GUIDELINES: > > >Send a plain text email to [EMAIL PROTECTED] > > >In the message body, put just two words: INTRO rbase-l > > >================================================ > > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > >In the message body, put just two words: UNSUBSCRIBE rbase-l > > >================================================ > > >TO SEARCH ARCHIVES: > > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > > > ================================================ > > TO SEE MESSAGE POSTING GUIDELINES: > > Send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: INTRO rbase-l > > ================================================ > > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > > In the message body, put just two words: UNSUBSCRIBE rbase-l > > ================================================ > > TO SEARCH ARCHIVES: > > http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
