Microsoft KB Archive/319983

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

Article ID: 319983

Article Last Modified on 12/4/2007

-

APPLIES TO


 * Microsoft Office Visio Professional 2007
 * Microsoft Office Visio Professional 2003
 * Microsoft Visio 2002 Professional Edition
 * Microsoft Visio Network Center
 * Microsoft Visio Network Center

-



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:

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

Additional query words: prb VISIO2003 VSO2003 VISIO2007 VSO2007

Keywords: kbtshoot kbprb KB319983

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.