You cannot find the Generate command in the Database Model Diagram of Visio 2002 Professional (319983)

SYMPTOMS

When you use the Database Model Diagram solution in Microsoft Visio 2002 Professional, there is no option with which 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 Microsoft Visio 5.0 Enterprise.

CAUSE

The Generate feature is not available with the Database Model Diagram solution in Visio 2002 Professional.

In Visio 2002, the Generate feature and other advanced database modeling features are included with Microsoft Visio Enterprise Architect. Visio Enterprise Architect includes full-featured database and software modeling solutions in addition to all of the solutions that are in Visio 2002 Professional. Visio Enterprise Architect is available only as a part of Microsoft Visual Studio .NET Enterprise Architect.

RESOLUTION

To use the advanced Visio-based database and software modeling features, obtain and install Visual Studio .NET Enterprise Architect. For more information about Visual Studio .NET Enterprise Architect, visit the following Microsoft Web site:

http://msdn.microsoft.com/vstudio/productinfo/overview/eaoverview.asp

For more information about how to purchase Visual Studio .NET Enterprise Architect, visit the following Microsoft Web site:

http://msdn.microsoft.com/vstudio/howtobuy/default.asp

MORE INFORMATION

For more information, and a feature-by-feature comparison of the database and software modeling solutions in Visio Professional 2002 and Visual Studio .NET Enterprise Architect, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/Dnvisio02/html/visDBcomp.asp?frame=true