You cannot find the Generate command in the Database Model Diagram of Visio Professional 2007, Visio Professional 2003, or Visio 2002 Professional

Article translations Article translations
Article ID: 319983 - View products that this article applies to.
This article was previously published under Q319983
Expand all | Collapse all

SYMPTOMS

When you use the Database Model Diagram solution in Microsoft Visio 2002 Professional, in Microsoft Office Visio Professional 2003, or in Microsoft Office Visio Professional 2007, there is no option to use to generate database schema or Data Definition Language (DDL) scripts. The Generate command is not displayed on the Database menu as it is in Microsoft Visio 2000 Enterprise Edition and in Microsoft Visio Enterprise 5.0.

CAUSE

This issue occurs because the Generate feature is not available with the Database Model Diagram solution in Visio 2002 Professional, in Visio Professional 2003, or in Visio Professional 2007. In Visio 2002 and in Visio 2003, the Generate feature and other advanced database modeling features are included with Microsoft Visio Enterprise Architect.

RESOLUTION

To resolve this issue, install a Visual Studio Team System that contains Visio Enterprise Architect.

For more information, visit the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/vstudio/aa718806.aspx
For more information about Visual Studio, visit the following Microsoft Web site:
http://www.microsoft.com/vs

MORE INFORMATION

Visio Enterprise Architect includes full-featured database and software modeling solutions in addition to all the solutions that are available in Visio 2002 Professional. Visio Enterprise Architect is available only as a part of Microsoft Visual Studio .NET Enterprise Architect, or as part of certain editions of Microsoft Visual Studio 2005, such as Team System or Enterprise Architect.

The version of Microsoft Visio Enterprise Architect that is included with Visual Studio .NET resembles Visio 2002 Professional. However, Visual Studio .NET Enterprise Architect has more features, such as database forward engineering and UML reverse engineering and UML forward engineering.

The version of Microsoft Visio Enterprise Architect that is included with some Visual Studio 2005 editions resembles Visio Professional 2003. However, Visual Studio 2005 Enterprise Architect has more features, such as database forward engineering and UML reverse engineering and UML forward engineering. There is currently no Visio Enterprise Architect edition that resembles Visio Professional 2007.

For more information, and a feature-by-feature comparison of the database and software modeling solutions in Visio 2002 Professional and in Visual Studio .NET Enterprise Architect, visit the following Microsoft Web site:
http://msdn2.microsoft.com/en-us/library/Aa140347(office.10).aspx

Properties

Article ID: 319983 - Last Review: December 4, 2007 - Revision: 2.2
APPLIES TO
  • Microsoft Office Visio Professional 2007
  • Microsoft Office Visio Professional 2003
  • Microsoft Visio 2002 Professional Edition
  • Microsoft Visio Network Center
  • Microsoft Visio Network Equipment
Keywords: 
kbtshoot kbprb KB319983

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com