VS 2012 Express 和 SQL Server 2012 Express 的正确安装顺序 [英] Proper order of installation VS 2012 Express and SQL Server 2012 Express

问题描述

在没有安装任何 SQL Server 版本的 Win7 64 系统上，我安装了 Visual Studio 2012 for Web.我认为它会给我安装 SQL Server 2012 Express 的选项，但它没有.现在我想在安装 VS 后安装 Server 2012.知道 SQL Server 是在 VS 2012 之前发布的，SQL Server 会识别 VS 2012 并将其自身集成到其中吗?不想在VS之前卸载VS安装SQL.

On Win7 64 system which didn't have any editon of SQL Server installed, i installed Visual Studio 2012 for Web. I tought it will give me option to install SQL Server 2012 Express but it didn't. Now I want to install Server 2012 after I installed VS. Will SQL Server recognize VS 2012 and integrate it self in it knowing that SQL Server was release before VS 2012? I don't want to uninstall VS to install SQL before VS.

推荐答案

是的，有特定的顺序.如果您先安装 SQL2012，您将无法在 VS2012 的对象资源管理器中打开 .sql 文件(去过那里，做过).这是一个通过特殊的SQL Server Data Tools - 2012 年 12 月更新"修复的错误.可悲的是，此更新不会出现在常规 Windows 更新(在我的 Windows 8 上)中，也不会出现在安装 SP1 之前或之后检测到的任何 SQL 更新中.

Yes, there is a specific order. If you install SQL2012 first, you won't be able to open .sql files in VS2012's object explorer (been there, done that). This is a bug that was fixed with a special "SQL Server Data Tools - December 2012 update". The sad thing is, this update does not appear in the regular Windows Updates (on my Windows 8), nor on any SQL updates detected before or after SP1 was installed.

因此，正确的顺序是:先VS2012，然后是SQL2012.尤其是在应用服务包时.

Therefore, the proper order is: VS2012 first, and then SQL2012. Especially when applying service packs.

来源:

http://blog.wharton.com.au/category/sql-server-数据工具/

如果您碰巧先安装 SQL2012，然后安装 VS2012，您将需要 2012 年 11 月更新来修复您的 .sql 文件:

If you happened to install SQL2012 first, and then VS2012, you will need the November 2012 Update to fix your .sql files:

http://msdn.microsoft.com/en-us/jj650015

更多背景知识...我从 2002 年开始使用 Visual Studio.在安装 Visual Studio 2003、2005、2008、2010 和最近的 2012 年之前，我一直安装自己的 SQL Server 20XX 版本.这是因为我从未使用过 Visual Studio 附带的 SQL Server Express.对于早期版本的 SQL Server Express 施加的 2 GB 限制，我的数据文件太大了.通过首先安装 SQL Server，这允许我在机器上使用根实例名称，而不是在过去十年中 SQL Express 接管它.

A bit more background... I've been using Visual Studio since 2002. I have always installed my own SQL Server 20XX edition before I installed Visual Studio 2003, 2005, 2008, 2010, and most recently 2012. This is because I never used the SQL Server Express that came with Visual Studio. My data files were far too large for the 2 GB limits imposed by earlier editions of SQL Server Express. By installing SQL Server first, this allowed me to use the root instance name on the machine, instead of SQL Express taking it over in the past decade.

我从来没有遇到过这个命令的问题，直到 VS2012 和 SQL2012.如上面的博客文章所述，先安装 VS2012，然后再安装 SQL Server.

I never had a problem with this order, until VS2012 and SQL2012. As noted in the blog article above, install VS2012 first before SQL Server.

这篇关于VS 2012 Express 和 SQL Server 2012 Express 的正确安装顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！