Visio 2007 - 如何将 ERD 导出到 sqlserver 架构 [英] Visio 2007 - how to export ERD to sqlserver schema
问题描述
我在 Visio 中碰到了一个小砖墙.我有一个我正在运行的项目，它托管在 sqlserver 下，并且受到 Visio 2007(通过第 3 方)中的大量模型更改的影响.
I've hit a minor brick wall here in Visio. I've got a project that I'm running that's hosted under sqlserver and is subject to lots of model changes in Visio 2007 (via a 3rd party).
我的问题是，由于 visio 2007 不允许我导出 ERD(由第 3 方提供)，我必须扫描模型并使用新/修改后的属性手动更新数据库.可以想象，这对胆小的人来说不是一项任务，尤其是当本节中的表数已超过 50 时.我非常希望能够通过单击按钮将工程师转发到 SQL".
The problem for me is that due to visio 2007 not allowing me to export the ERD (supplied by the 3rd party), I have to scan the model and manually update the database with the new/amended properties. As you can imagine, not a task for the faint hearted, especially as the table count has gone beyond 50 in this section. I'd dearly love to be able to just 'forward engineer to SQL' at the click of a button.
现在，我意识到 visio 2003 和Visio Enterprise Architect"版本确实允许这样做，但是，我只是使用普通的 Visio Professional 2007，因此我无法使用该选项.我也确实在互联网上看到了一些解决此问题的建议，但都不适合我的用途:
Now, I realise that visio 2003 and the "Visio Enterprise Architect" versions did allow this, however, I'm just on plain Visio professional 2007, so that option isn't available to me. I did also see a few suggestions on the internet to get around this issue but neither were suitable for my uses:
仅适用于 visio 2010(因此不适合)
visio 2010 only (therfore not suitable)
visio 2003 和 .net 1.1.框架 - 嗯
visio 2003 with .net 1.1. framework - hmmm
我正在想象"一个可能会在 2007 年出现的插件.
I'm 'imagining' an addin that someone may have created that will hook into 2007.
手指 xx'd - 有什么想法吗??
Fingers xx'd - any thoughts??
- 我实际上是按照上面的链接通过 Orthoganol 工具箱让它工作的.只需安装 .net 1.1 (yikes) 就可以了，一切正常.而不是删除问题，我会离开，以防其他人有类似的需求.
[edit] - i actually got it working via the Orthoganol Toolbox as per link above. just a matter of installing .net 1.1 (yikes) and it all works fine. Rather then delete the question, I'll leave as is in case anyone else has a similar need.
推荐答案
有关答案，请参阅上面我对 .net 1.1 安装和 Orthoganol Toolbox 链接的编辑.
for the answer, see my edit above re .net 1.1 installation and the Orthoganol Toolbox link.
不漂亮，但让我摆脱了困境.
not pretty but got me out of a jam.
这篇关于Visio 2007 - 如何将 ERD 导出到 sqlserver 架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
