Randy:
It worked like a charm!
Many thanks.
Tony
Anthony Schmidt
President
The Computery Ltd.
One East Main Street
Bay Shore, NY 11706
Voice 631-665-8100
Fax 631-969-5988
----- Forwarded by Anthony Schmidt/BayShore/SGU_LN on 10/04/2001 06:34 PM
-----
Anthony Schmidt
09/30/2001 03:03 PM
To: [EMAIL PROTECTED]
cc:
Subject: Re: Documenting database schema
Randy:
Thanks, I'll give it a try next week.
Tony
Anthony Schmidt
President
The Computery Ltd.
One East Main Street
Bay Shore, NY 11706
Voice 631-665-8100
Fax 631-969-5988
----- Forwarded by Anthony Schmidt/BayShore/SGU_LN on 09/30/2001 03:00 PM
-----
randyp <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/29/2001 10:41 PM
Please respond to rbase-l
To: [EMAIL PROTECTED]
cc:
Subject: Re: Documenting database schema
Tony,
Using the professional version of Microsoft Visio 2000 SR1.
Select File, New, Database, Database Model Diagram.
A new option: Database will appear with the other options at the top of
the
screen.
Select Database, Reverse Engineer.
>From the options, choose the installed Visio driver for Microsoft Access.
Then choose new next to ODBC data source. I chose a system data source.
Next I selected the RBase database driver (*.rb1) 6.50.00.00 (on my
system).
To finish give it a data source name which I chose as ConComp1.
Then I browsed to highlight the ConComp.rb1 database in my RBTI, RBWin65,
Samples, ConComp subdirectory.
Next I highlight ConComp1 as the data source. Press next twice.
Select the tables you want. I selected them all. Press finish.
In the process, if you select all, there may be some data source errors.
Don't worry about them.
A screen appears with a list of table view names on the left, and the
processing results on the right. A shadow box is to the left of each
name. You can drag each name individually to your Visio page.
A box appears. It lists the name of the table, the primary key,
any foreign keys, and other column names.
You can highlight all the names and drag them to the Visio Page.
It will provide connecting arrows between related tables using the
primary and foreign key relationships. Then you have to move the
tables to minimize the number of crossing lines and to straighten
everything up.
I cannot speak to the issue of the Oterro ODBC driver.
If you would like a copy of the Visio drawing.vsd file which I
created, I would be happy to forward it to you. I saved it in
HTML but there are several files and it works from one
directory, but not from my A: drive, so I'm not sure which
files are required in order to see the diagram in HTML.
Sami Aaron uses Visio very effectively in database design.
Developer's Conference Materials in previous years also provide
some detailed procedures which may be helpful.
Randy Peterson
[EMAIL PROTECTED] wrote:
> Does anyone know of a way to document the database schema in a graphical
> way? Access and SQLServer, among others, can do this.
>
> I'd like to be able to show, in a diagram, all of the tables in my
database
> along with linking info, as well as PKs and FKs.
>
> I've tried to use Visio to do this, but Visio doesn't seem to like the
> Oterro ODBC driver (either 2.0 or 2.5 beta) and although it allows me to
> connect to the database, it won't display any tables.
>
> Thanks
>
> Tony
>
> Anthony Schmidt
> President
> The Computery Ltd.
> One East Main Street
> Bay Shore, NY 11706
>
> Voice 631-665-8100
> Fax 631-969-5988
