sql-server - SSDT 2013 新数据库项目丢失

Question

这可能是我的设置中的一个小错误，但我似乎无法找到我在使用 SQl Server 停止 SSDT 2013 并打开以创建新数据库模板时出错的地方

请看图片

我希望在 sql 模板列表中包含创建新数据库项目的选项有人可以告诉我我错过了什么吗？

提前致谢

Answer 1

对于数据库项目，您需要安装支持它的 Visual Studio 版本 - 在您的情况下，您似乎运行了独立的 SSDT-BI 安装程序，它安装了 SSIS、SSAS 和 SSRS 模板。这不包括数据库项目模板。您需要的是安装支持的 VS 版本之一 - 有 2 个 Express 版本(Web Express 和 Windows 桌面 Express)和 3 个付费版本(Premium、Pro、Ultimate)。这是来自 SSDT blog post 的引述解释一下:

Visual Studio 2013 - VS 2013 now has SQL Server tooling built in and shipped as part of the core product. Database Projects, SQL tools (such as schema compare & data compare), and the online experiences through SSOX are all included with the RTM version. We have full project and SSOX support in VS Express for Web and Express for Windows Desktop, so we have discontinued our stand-alone integrated shell offering. We have a component update feed that will use VS Update to push notification to users. To manually check for updates, go to the Tools > Extensions and Updates... menu to open the dialog. We will continue to post announcements on our blog and forum that a release is available and what is included in that update.