在 Visio 中对我的数据库进行逆向工程时，我无法添加视图 [英] I cannot add views when reverse engineering my database in Visio

问题描述

我正在尝试将 2012 SQL Server 的一部分反向工程到 Microsoft Visio 2010 中.视图选项呈灰色显示.视图是我试图记录的过程不可或缺的一部分，如果没有它们，图表将毫无用处.除了手动输入视图之外，有没有人有其他简单的解决方法?

I am trying to reverse engineer parts of a 2012 SQL Server into Microsoft Visio 2010. The views option is greyed out. The views are integral to the processes I am trying to document, and the diagram will be useless without them. Does anyone have an easy work-around other than manually inputting the views?

推荐答案

您可能使用了错误的"数据提供程序对数据库进行逆向工程，这就是禁用视图的原因.Visio 未更新以支持较新的 SQL Server 版本存在一些问题.请尝试以下操作:

You are probably using "wrong" data provider to reverse engineer the database, and that is the reason why views are disabled. There are some issues with Visio not being updated to support newer SQL server versions. Try the following:

1. 启动逆向工程"向导
2. 选择通用 OleDb 数据提供程序(不是Microsoft SQL Sver").点击下一步.
3. 弹出对话框，在那里选择 SQL Native Client，然后(在连接"选项卡上)您的服务器和数据库.单击确定".
4. 现在应该启用视图"复选框.

1. Start "reverse engineer" wizard
2. Select Generic OleDb data provider (not the "Microsoft SQL Sver"). Click Next.
3. The dialog pops up, select SQL Native Client there, then (on the "Connection" tab) your server, and your database. Click OK.
4. Now the "views" checkbox should be enabled.

这篇关于在 Visio 中对我的数据库进行逆向工程时，我无法添加视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！