asked on 5/17/2011

Using a Database Model Diagram in microsoft sql sever 2005

Dear All,

I have created a Database Model diagram under microsoft office visio 2007.
This project contains tables and views.
The question is how i can benefit from this project?
If there is any method to use this project in mssql server 2005 or i should to create also al the tables and views in mssql server 2005.

Microsoft Visio Microsoft SQL Server 2005

Last Comment

Scott Helmers

5/18/2011

Scott Helmers

5/17/2011

Unfortunately, there is no longer a "forward engineering" capability in Visio. Many years ago, Visio did include a way to create database tables from a Visio database model diagram, but that option was removed a decade ago.

I realize this doesn't help in your present situation, but you can do the reverse, i.e., you can point Visio at an existing database and "reverse engineer" a data model. This option is available in the Professional edition Visio 2007 and the Professional and Premium editions of Visio 2010.

Scott Helmers

5/17/2011

One more thing to add to my post above: the forward engineering capability does still exist in a special version of Visio -- Visio for Enterprise Architects -- that is only available with Visual Studio and an MSDN subscription. See the note in the middle of this help page:
http://office.microsoft.com/en-us/visio/HA101154881033.aspx

MKItani

5/18/2011

ASKER

Thank u for your interest but can u send me a link to download visio for enterprise architect 2002 or a later version

ASKER CERTIFIED SOLUTION

Scott Helmers

5/18/2011

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial