Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Visio question

Posted on 2008-09-30
2
Medium Priority
?
543 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

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 …
Book Review: Using Microsoft Visio 2010 by Chris Roth   Disclaimer: The author of Using Visio 2010 is a friend and fellow Visio MVP. Whether you’re new to Visio or are upgrading to Visio 2010 from a previous version, you will find a lot to like…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Suggested Courses

609 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