Click here to Skip to main content
15,895,667 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have a complex diagram in Visio Online Plan 2 Version 1902 and would like to convert it into database DDL scripts so I could generate database tables directly, not manually

I did try to google that kind of possibility for Microsoft Visio, but all answers date back to 10 years ago and all add-ins have long been deprecated.

What is available nowadays for forward engineering in Microsoft Visio?

Thank you in advance for everyone's help

What I have tried:

Found no solution online. Looked for a solution, and every single solution is either deprecated or extremely old
Posted
Updated 6-Nov-19 7:06am

1 solution

I found this, but it is about reverse engineering: Reverse engineer an existing database into a database model - Visio[^]

I found this in a Dutch page Een databasemodel maken (ook entiteitsrelatiediagram genoemd) - Visio[^]
Translated it says:
Quote:
Note: Visio for Enterprise Architects provides the full suite of database modeling functions, including reverse engineering and forward engineering. Visio for Enterprise Architects is included in the MSDN Premium subscription. This is available with Visual Studio Professional and role-based Visual Studio Team System editions.
But this is probably not about the online version.

So I would recommend taking a look at ApexSQL Data modeling or ERBuilder which are available in a free version: https://www.slant.co/topics/10827/~relational-database-design-and-modelling-tools[^]

Another idea might be to use Draw.io which is free and allows to import Visio diagrams: https://www.slant.co/topics/2357/~online-and-free-visio-replacements[^]
Import and export VSDX files – draw.io[^]
 
Share this answer
 
v3
Comments
Member 13304618 6-Nov-19 15:24pm    
Thank you very much for your suggestions

Unfortunately, I already have a diagram completed in Microsoft Visio and need to create corresponding DDL's

I know that ages ago Microsoft did offer forward engineering, not it doesn't look like it does
RickZeeland 6-Nov-19 15:34pm    
See updated solution with Draw.io !
Member 13304618 6-Nov-19 22:25pm    
Thank you very much. I was able to import my Visio diagram into draw.io, but it doesn't look like draw.io has the capability to export its diagram into SQL (DDL)
RickZeeland 7-Nov-19 2:22am    
No, could not find that either, but you can always ask the good people at Draw.io if they are willing to implement that export functionality :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900