使用SQL Server 2008在Visio中进行数据库图表反向工程 [英] Reverse Engineering for Database Diagramming in Visio with SQL Server 2008

问题描述

我需要反向工程Microsoft SQL Server 2008以创建Microsoft Visio 2007数据库模型图。所以我从数据库菜单中选择反向工程师连接到数据库。

I need to reverse engineer a Microsoft SQL Server 2008 in order to create a Microsoft Visio 2007 Database Model Diagram. So I choose "Reverse Engineer" from the Database menu to connect to the DB.

我配置了Microsoft SQL Server Visio驱动程序，使用SQL Server Native Client 10.0 ODBC驱动程序。之后，我创建了一个用户DSN连接到我的数据库。此DSN工作（至少提供的测试成功）。在反向工程师向导中单击下一步后，Visio请求我提供的我的凭据，但是单击确定后，我收到以下消息：

I configured the Microsoft SQL Server Visio driver so that is uses SQL Server Native Client 10.0 as the ODBC driver. Afterwards I created a User DSN which connects to my DB. This DSN works (at least the provided test is successful). After clicking next in the Reverse Engineer Wizard, Visio kindly asks for my credentials which I properly provide, but after clicking OK I receive the following message:

当前选择的Visio驱动程序与数据源不兼容。

The currently selected Visio driver is not compatible with the data source.

我尝试使用旧的SQL Server ODBC驱动程序，重新配置Visio驱动程序当然。它不工作。

I tried using the old SQL Server ODBC driver, by also reconfiguring the Visio driver of course. It does not work too.

推荐答案

从 Microsoft支持通过Microsoft论坛：

From Microsoft support via the Microsoft forums:

进一步调查显示Visio 2007的预期行为。当Visio使用Visio SQL Server驱动程序打开连接时，它会检查服务器版本，并且自从SQL Server 2008在Visio 2007之后发布时，它不会将SQL Server 2008识别为受支持的版本并关闭连接。您可以等待识别SQL Server 2008的Visio的未来版本或使用可以成功打开与SQL Server 2008的连接的Visio Generic ODBC驱动程序。第三个选项是使用SQL Server 2005的副本进行初始反向工程。 Visio小组已知道此问题。

Further investigation reveals that this is expected behavior for Visio 2007. When Visio opens a connection using the Visio SQL Server Driver it checks the server version and since SQL Server 2008 shipped after Visio 2007 it doesn't recognise SQL Server 2008 as a supported version and closes the connection. You can wait for a future version of Visio to ship which does recognise SQL Server 2008 or use the Visio Generic ODBC driver which can successfully open connections to SQL Server 2008. A third option is to use a copy of SQL Server 2005 for initial reverse engineering. The Visio team is aware of this issue.

这篇关于使用SQL Server 2008在Visio中进行数据库图表反向工程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！