SQL Server Express(2012)和LocalDB之间有区别吗? [英] Is there a difference between SQL Server Express (2012) and LocalDB?

问题描述

以他出色而又受欢迎的比较图表，ErikEJ在 SQL Server Express 2012 和 SQL Server 2012 LocalDB 之间进行了区分.但是，我在MSDN文档的其他任何地方都找不到这样的区别( MS SS12官方书或在此MSDN页面上，它被称为"SQL Server 2012 Express LocalDB ").

In his excellent and popular comparision chart, ErikEJ draws a distinction between SQL Server Express 2012, and SQL Server 2012 LocalDB. However, I can't find such a distinction anywhere else in the MSDN documentation ("LocalDB" isn't even mentioned in the official MS SS12 book or on the MSDN SQL Edition comparison page.) This leads me to suspect that Express and LocalDB aren't really two separate products as ErikEJ suggests, but rather just two different terms for the same thing (which would explain why, on this MSDN page, it is called "SQL Server 2012 Express LocalDB").

如果两种产品之间确实存在差异，谁能指出我一些比较它们的官方文档?

If there really is a difference between the products, can anyone point me to some official documentation comparing them?

推荐答案

好的，我想我已经找到了自己问题的答案. (它埋在 SS Express产品页面.)

OK, I think I have found the answer to my own question. (It was buried under the tabs on the SS Express product page.)

以下是我在该页面上找到的LocalDB特色的摘要:

Here is a summary of the distinctives of LocalDB I found on that page:

• LocalDB是SQL Server Express Edition的轻量级部署选项，具有较少的先决条件和更快的安装.
• LocalDB具有与SQL Express相同的所有可编程性，但是在用户模式" *下与应用程序一起运行，并且不作为服务.
• LocalDB不适用于多用户方案或用作服务器. (如果需要接受远程连接或远程管理，则需要SQL Server Express.)
• 带有工具的Express"(包括SS Management Studio Express，Azure等)可以与LocalDB一起使用，也可以不结合使用. (使用高级服务进行快递"也是如此.)

• LocalDB is a lightweight deployment option for SQL Server Express Edition with fewer prerequisites and quicker installation.
• LocalDB has all of the same programmability features as SQL Express, but runs in "user mode"* with applications and not as a service.
• LocalDB is not intended for multi-user scenarios or to be used as a server. (If you need to accept remote connections or administer remotely, you need SQL Server Express.)
• "Express with Tools" (which includes SS Management Studio Express, Azure, etc) can be used with LocalDB or without. (The same goes for "Express with Advanced Services".)

更新:我刚刚在 Windows上找到了这个有用的描述IT Pro(12月7日，第23页):

LocalDB不是SQL Server Express，也不是SQL Server Compact. LocalDB与其他版本的sqlservr.exe引擎使用相同的sqlservr.exe引擎 SQL Server，但它在用户模式下运行-不作为服务运行.现"LocalDB"为 用于SSDT之类的工具进行离线开发，以确保 您开发的代码与您的产品100％兼容 SQL Server数据库.

LocalDB isn’t SQL Server Express, nor is it SQL Server Compact. LocalDB uses the same sqlservr.exe engine as the other editions of SQL Server, but it runs in user mode—not as a service. LocalDB is used for offline development by tools such as SSDT to ensure that the code you develop is 100-percent compatible with your production SQL Server database.

如果我正确地阅读了此内容，则LocalDB似乎更像是Express的配置选项，而不是完全独立的产品.因此，显然，如果我下载Express(或带有工具的Express)，则可以选择安装LocalDB版本，该版本据说比完整的Express更容易(零配置"). (更新:使用VS2012，

If I am reading this correctly, LocalDB seems to be more like a configuration option of Express than an entirely separate product. So apparently if I download Express (or Express w/ Tools), I will have the option to install the LocalDB version, which is supposedly easier ("zero-configuration") than the full Express. (Update: with VS2012, LocalDB comes installed by default.)

根据这篇文章的意思是当前Visual Studio 2010不适用于LocalDB." (至少现在至少要使用SS Management Studio.)

One other important distinction, according to this post, is that "currently Visual Studio 2010 doesn't really work with LocalDB." (We have to use SS Management Studio instead, at least for now.)

*(用户模式"或用户实例"的概念是LocalDB的关键特征.实际上，根据)

*(The concept of "User Mode" or "User Instances" is a key distinctive of LocalDB. In fact, according to this post, "LocalDB can be seen as an upgrade of the User Instances feature of SQL Server Express." For more about User Instances, refer to the MSDN blogpost "What is a RANU?")

这篇关于SQL Server Express(2012)和LocalDB之间有区别吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！