?
Solved

Visio question

Posted on 2008-09-30
2
Medium Priority
?
540 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 31

Accepted Solution

by:
Scott Helmers earned 2000 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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article I’ll describe a mashup of containers and lists that meet a real-world need. Prior to reading this ar…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

770 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