exporting SQL from a Viso diagram

Question

Is there a method to export SQL statements from a Viso 2003 entity-relationship diagram?

Check these add-ins for Visio forward engineering http://www.sqlbi.com/tools/visio-forward-engineer http://forwardengineer.codeplex.com/ — , Oct 04 '12 at 14:12

score 2 · Answer 1 · answered Sep 03 '13 at 08:00

2

If you're using Visio 2010 and have a 64-bit OS, this add-in may help: http://forwardengineer.codeplex.com/

answered Sep 03 '13 at 08:00

user1058946

243
2
3
14

This is a very useful tool, the current version also adds validates the design if you have missing info in the diagram or duplicates and other useful validations. – Elhussein Hashem Feb 04 '15 at 10:34

score 0 · Answer 2 · answered Aug 17 '10 at 19:24

Depends on which edition of Visio you have.

There's an Enterprise edition pr Professional edition which has a database menu item that will export (and import) database schema from Visio.

If you have some lower edition, you may not have any database engineering or reverse engineering features.

score -3 · Answer 3 · answered Aug 17 '10 at 19:15

I don't think it's possible with Visio, the best you can do is go to the SQL Server Diagram window (Database Diagram) and right click on the empty white space on the Diagram-- there's an option "Copy Diagram to Clipboard", you can paste in MSPaint or Photoshop.

exporting SQL from a Viso diagram

3 Answers3

Linked