You are currently offline, waiting for your internet to reconnect

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

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q319983
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:For more information about Visual Studio, visit the following Microsoft Web site:
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:
prb VISIO2003 VSO2003 VISIO2007 VSO2007
Properties

Article ID: 319983 - Last Review: 12/04/2007 22:13:58 - Revision: 2.2

  • Microsoft Office Visio Professional 2007
  • Microsoft Office Visio Professional 2003
  • Microsoft Visio 2002 Professional Edition
  • Microsoft Visio Network Center
  • Microsoft Visio Network Equipment
  • kbtshoot kbprb KB319983
Feedback