Using a Database Model Diagram in microsoft sql sever 2005

MKItani
MKItani used Ask the Experts™
on
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.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Scott HelmersVisio Consultant, Trainer, Author, and Developer
Most Valuable Expert 2011

Commented:
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 HelmersVisio Consultant, Trainer, Author, and Developer
Most Valuable Expert 2011

Commented:
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

Author

Commented:
Thank u for your interest but can u send me a link to download visio for enterprise architect 2002 or a later version
Visio Consultant, Trainer, Author, and Developer
Most Valuable Expert 2011
Commented:
There isn't a general download available as far as I know. You need to have an MSDN Premium subscription and Visual Studio. If you do have an MSDN Premium subscription, log in and search from there.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial