Solved

Visio question

Posted on 2008-09-30
2
523 Views
Last Modified: 2012-05-05
Hi

I would like to produce a database schema diagram usng viso, I understand there is a de-enginering tool available in one of the versions, I am running visio 2005 professional but does seem to have the availble options.

Cheers
0
Comment
Question by:ac_davis2002
2 Comments
 
LVL 30

Accepted Solution

by:
Scott Helmers earned 500 total points
ID: 22605010
In Visio 2007 Professional, select File/New/Software and Database/Database Model Diagram. When the blank drawing is open, you'll see that there is a new menu entry called Database. Select Database/Reverse Engineer... and that will launch the reverse engineering wizard (see first dialog below).

In Visio 2003 Professional, select File/New/Database/Database Model Diagram. The rest is the same.

You mention that you have Visio 2005 Pro, but that version doesn't exist as far as I know. I've never used it but I know there is a special product called Visio for Enterprise Architects -- perhaps there is a 2005 version of it. The lineage for Visio is:
  • Visio 2002 (also known as Visio 10 if you select Help/About)
  • Visio 2003 (Visio 11)
  • Visio 2007 (Visio 12)
All of the above come with both Standard and Professional editions and only the Pro edition includes the database model wizard.

For additional information on the database model wizard:
     http://office.microsoft.com/en-us/visio/HA101154851033.aspx?pid=CH100648911033
or go to
     http://office.microsoft.com/en-us/visio/
and search for database model

db-wizard.jpg
0
 

Author Closing Comment

by:ac_davis2002
ID: 31501485
Hi Scott

thanks for the thoroughly detailed answer

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Visio 2010 - 4 362
Visio 2013 - What is this mouse pointer? 2 365
Visio: set Org-Chart Layout per VBA 6 410
Topology_issues 3 50
The Question Several times in recent years, someone has posted a question at EE asking whether they could display the Windows directory structure – folders and subfolders – using Visio. When one person specifically asked about displaying directory …
Meetings to discuss business process can waste time, and often do .  The meeting's dialog can get confusing when participants have different professional perspectives and backgrounds.  A jointly-developed process picture helps wade through the confu…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now