Visual Studio 2012中Database Explorer中的Missing Diagram文件夹 [英] Missing Diagram folder in Database Explorer at Visual Studio 2012

问题描述

当我突然数据库图文件夹从数据库浏览器中消失时，我正在设计一个网站。我不知道现在发生了什么，现在要做什么，因为我迫切需要它继续工作 - 手动添加表到数据库不是我的选择。

I was in a middle of designing a website when suddenly Database Diagram folder just disappeared from the Database Explorer. I have no idea what happened and what to do right now, as I desperately need it to continue my work - adding tables to database manually are not an option for me.

我一直在寻求解决方案一天，我甚至重新安装了Visual Studio和本地IIS服务器，但根本没有帮助。

I've been seeking for the solution for a whole day, and I even re-installed the Visual Studio and local IIS server, but it wasn't helpfull at all.

是否有任何方法可以使功能回到或至少有免费的工具可以在Windows 8 x64上工作，并有基于图表的数据库设计师为MSSQL 2008？

Is there any way to bring the feature back or at least is there any free tool that would work on Windows 8 x64 and has diagram-based database designer for MSSQL 2008?

编辑

似乎微软删除了图表的目的。这在业务逻辑中是相当合乎逻辑的 - 为什么有人在Visual Studio中内置基础工具（图表）时会购买Server Management Studio？

EDIT

It seems that Microsoft removed the diagramming for purpose. Which is pretty logical in a business logic - why would somebody buy Server Management Studio if they have basic tool (diagramming) built in Visual Studio?

推荐答案

1）数据库图是SQL Server的一个功能，而不是Visual Studio。我不知道VS用来显示该文件夹，但是您可能想要使用DBA验证或检查数据库的配置，以查看某人是否不仅仅是禁用了使用图表的能力。您是否尝试刷新与数据库服务器的连接？

1) Database Diagram is a feature of SQL Server, not Visual Studio. I am not sure what VS uses to display that folder but you might want to verify with your DBA or check the configuration of the database to see if someone has not just disabled the ability to use diagrams. Have you tried refreshing your connection to the database server as well?

2）如何手动向表中添加表不是一个选项？如果你自己依赖于做某事，只有这样一种方式，你将在以后的项目中为自己设置灾难，就像你目前的一样。 VS内还有其他方式创建表，它可能不是图表提供的图形图片。

2) How is adding tables to a database manually not an option? If you get yourself dependent on doing things one way and only that one way you are setting yourself up for disaster in future projects, as you are in your current one. There are other ways from within VS to create a table, it just may not be a graphical picture that diagrams offers.

3）您是否通过SSMS查看数据库看看图表文件夹是否显示在那里？

3) Have you looked at the database through SSMS to see if the diagrams folder shows up there?

这篇关于Visual Studio 2012中Database Explorer中的Missing Diagram文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！