I have created a database model in Visio Professional (2003). I know that the Enterprise version has the ability to create a DB in Sql Server based on the data in Visio. I do not have the option to install Enterprise. Aside from going through the entire thing one table and relationship at a time and creating the whole database from scratch, by hand, can anyone recommend any tool/utility/method for converting the visio database model into a Sql Script that can be used to create a new DB in Sql Server?
A:
I have not done this, but here it goes.
- Convert Visio file to Visio XML format.
- Use Dia for Windows and Dia VDX plug-in to convert Visio XML into Dia.
- Use tedia2sql to generate SQL.
eed3si9n
2008-09-01 10:35:06
I tried to download this. It looks like the VDX plugin has been integrated with the main Dia program, as it did offer support to open VDX files. However, it does not support all parts of Visio files. With regards to tedia2sql, it seems like there is no binary download, and in order to get it to work, I would have to download additional modules and compile it myself. Since according to its website it hasn't even been thoroughly tested for MSSQL, I don't think it is worth spending the time trying to get this working. Thanks for the links though.
Yaakov Ellis
2009-07-27 17:34:03
A:
If you can somehow obtain the type library from the enterprise version you can use VBA to get out the definitions. Secondhand enterprise architect versions of VS2002 and VS2003 can be had off ebay for a few hundred dollars.
ConcernedOfTunbridgeWells
2008-10-11 14:59:46