关于SQL Server Express和localdb的困惑 [英] confusion about SQL Server Express and localdb
问题描述
我需要在客户端计算机上部署带有数据库的WCF服务.我对SQL Server Express感到困惑.我需要验证以下所有内容.
I need to deploy a WCF service with a database on client machines. I am confused about SQL Server Express. I need to verify all of the following.
在App_Data文件夹中附加数据库文件时，是否仍需要在客户端计算机上安装SQL Server Express引擎(Windows服务)?
When attaching database files in the App_Data folder, do I still need to install SQL Server Express engine (Windows service) on client machines?
有一种称为SQL Server Express LocalDb 的形式.那不需要引擎(Windows服务)吗?但是我认为它需要先安装LocalDb.
There is a flavor called SQL Server Express LocalDb. That one does not need an engine (Windows service)? But I think it need a prerequisite installation of LocalDb.
SQL Server 2012引入了Localdb.SQLServer 2008没有localdb.对吗?我在MS网站上找不到2008版本.
Localdb is introduced with SQL Server 2012. There is NO localdb for SQL Server 2008. Correct? I could not find 2008 version on MS site.
推荐答案
我是否仍需要安装SQL Server Express引擎(一项Win服务) 在客户端计算机上?
Do I still need to install SQL Server Express engine (A win Service) on client machines?
是的，他们需要为您的应用程序安装它来查询数据库.真的无法解决它.
Yes, they need it installed for your application to query the database. Can't really get around it.
有一种叫做SQL Express localDb的风格.那不需要 引擎(双赢服务)?但我认为它需要精巧的安装 的本地数据库.
There is a flavor called SQL Express localDb. That one does not need an engine (win service)? but I think it need a perquisite installation of localdb.
是的，您仍然需要在客户端计算机上安装LocalDB.这样做很轻松，但是除非您确实需要Web服务的SQL Server实例的全部功能，否则我认为这是过分的.
Yes, you'd still need to install LocalDB on the client machine. It's pretty hassle-free to do, but I think it's overkill unless you really need the full features of a SQL Server instance for your webservice.
我强烈建议您使用 SQL Server精简版来代替LocalDB，它会执行您正在考虑的角色(您的WCF服务可以直接连接到客户端计算机上的数据库文件，而无需安装SQL Server，并且是轻量级的)，但是不需要安装(它只是作为DLL包含在WCF中)应用程序):
Instead of LocalDB I'd strongly recommend using SQL Server Compact Edition - it performs the role you're thinking of (your WCF Service can simply connect directly to the database file on your client machines without installing SQL Server, and is lightweight), but doesn't need to be installed (it's simply included as a DLL with your WCF application):
与其他版本的Microsoft SQL Server不同，SQL CE可以运行 正在处理托管它的应用程序.
Unlike other editions of Microsoft SQL Server, SQL CE runs in-process with the application which is hosting it.
LocalDB和SQL Server Compact吗?
LocalDB and SQL Server Compact?
小而简单的数据库，轻巧的安装，连接到 数据库文件-任何使用SQL的开发人员都将熟悉 服务器紧凑.相似之处并非偶然，因为我们的目标是 LocalDB应该像SQL Server Compact一样易于使用( 功能强大且与完整的SQL Server(如SQL Express)兼容.
Small and simple database, lightweight installation, connecting to a database file -- this will sound familiar to any developer using SQL Server Compact. The similarities are not accidental, as our goal for LocalDB was to be as easy to use as SQL Server Compact (while being as powerful and compatible with full SQL Server as SQL Express).
LocalDB与SQL Server之间存在显着差异 紧凑:
There are significant differences between LocalDB and SQL Server Compact:
执行模式:SQL Server Compact是一个进程内DLL，而LocalDB作为单独的进程运行.
Execution mode: SQL Server Compact is an in-proc DLL, while LocalDB runs as a separate process.
SQL Server CE类似于MS Access的更新版本，该文件与应用程序一起提供，该应用程序可以仅连接"到数据库文件，而无需安装任何数据库服务器，并且其语法/功能与SQL非常相似.服务器标准.
SQL Server CE is kind of like an updated version of MS Access, the file goes with the application which can "just connect" to the database file without involving any database server installation, and its syntax/features are very close to SQL Server standard.
这篇关于关于SQL Server Express和localdb的困惑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
