exporting SQL from a Viso diagram

Question

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

Answer 1

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.

Answer 2

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.

Answer 3

Don't know in much detail, but you should search for SQL Forward Engineering with Visio 2003 Professional. This might solve your problem. Refer to microsoft visio site for more details. By the way have you tried visio 2010? I've got visio trial version.. visio download is available at visiotoolbox. It has got many new features like dyanmic data driven diagrams and online sharing etc.