asked on

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.

Scott Helmers

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

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

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial