Visio 2007 - 如何将 ERD 导出到 sqlserver 架构
我在 Visio 中遇到了一个小问题。我正在运行一个项目，该项目托管在 sqlserver 下，并且会在 Visio 2007 中进行大量模型更改（通过第 3 方）。
我的问题是，由于 visio 2007 不允许我导出 ERD（由第 3 方提供），我必须扫描模型并使用新的/修改后的属性手动更新数据库。正如您所想象的那样，这对于胆小的人来说不是一项任务，尤其是当这个部分的桌子数量已经超过 50 个时。我非常希望能够通过单击按钮“将工程师转向 SQL”。
现在，我意识到 visio 2003 和“Visio Enterprise Architect”版本确实允许这样做，但是，我只是使用普通的 Visio professional 2007，因此该选项对我不可用。我也在互联网上看到了一些解决此问题的建议，但都不适合我的使用：
仅限 visio 2010（因此不适合）
visio 2003 与 .net 1.1。框架 - 嗯
我正在“想象”某人可能创建的插件这将持续到 2007 年。
手指 xx'd - 有什么想法吗？
[编辑] - 我实际上通过上面的链接通过 Orthoganol Toolbox 让它工作。只需安装 .net 1.1（哎呀）就可以了，一切正常。如果其他人有类似的需求，我将按原样保留，而不是删除该问题。
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).
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.
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 only (therfore not suitable)
visio 2003 with .net 1.1. framework - hmmm
I'm 'imagining' an addin that someone may have created that will hook into 2007.
Fingers xx'd - any thoughts??
[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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
有关答案，请参阅我上面关于 .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.