• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 545
  • Last Modified:

Visio question

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
ac_davis2002
Asked:
ac_davis2002
1 Solution
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
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
 
ac_davis2002Author Commented:
Hi Scott

thanks for the thoroughly detailed answer

0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now