Generating SQL scripts from Visio

Question

 

Hi,

Is it possible to generate SQL scripts (SQL Sever ) from Visio, then please explain me how I can achieve.

Answer 1

Hi,

 

I'm going to have to answer this question from memory, as I don't have Visio installed on this particular computer.

 

It definitely is possible to generate scripts to create your database and tables, constraints and so on. 

From memory, from an ERD diagram, it is something along the lines of Database-->Generate..  If that doesn't work, or you can't find the generate menu item on any of the menus then ask again, and I will have a look for you.  Alternatively you could take a look in the help files, or do a quick google search?

 

Good luck,

 

Martin Platt.

Answer 2

I googled and found that it is possible to generate SQL scripts from visio using Visio 2003 enterprise architect.

I don't have enterprise architect. I have Visio 2007, is it possible to generate sql script??? Any help would be highly appreciated :)

Answer 3

Short answer: No

Answer 4

Microsoft sucks for this stupid solution - discontinue support Forward Engineer ...

Ernikas

Answer 5

No....

Answer 6

You can see this: http://sqlblog.com/blogs/alberto_ferrari/archive/2010/04/16/visio-forward-engineer-addin-for-office-2010.aspx

Answer 7

http://forwardengineer.codeplex.com/