如果我的软件使用它，我是否必须在每个客户端上安装 sql server? [英] Do I have to install sql server on each client if my software uses it?

问题描述

如果我们用 c#(或基本上是 .Net)开发一些软件，我们不会将 Visual Studio 安装到任何客户端.客户端只需要安装所需的 .Net 框架(1.0、1.1、2.0、3.0 等)，我们就可以开始了.

If we develop some software in c# (or basically .Net), we don't install visual studio to any client. The client just have to have required .Net framework (1.0, 1.1, 2.0, 3.0 etc) installed and we are good to go.

同样，如果我们在 VC2008 中制作应用程序，他只需要有 Visual C++ 2008 运行时(可从 MS 站点免费获得，大约 4-5Mb).所以，基本上，我们只需要运行时环境.但是没有任何 SQL Server 2008 运行时(或者我不知道它?).

Same way, if we are making making an app in VC2008, he just needs to have Visual C++ 2008 runtime (available from MS site free, about 4-5Mb). So, basically, we just need runtime environment. but there isn't any SQL server 2008 runtime (or I am not aware of it?).

所以，我的问题是，如果我的软件使用 SQL Server 2008，客户端需要什么运行时(或其他任何东西)才能工作?

So, my question is if my software is using SQL Server 2008, what runtime (or anything else) will be required on client side for it to work?

另外，还有一件事，我看到有一个 SQL Server express 版本，我应该可以在部署中使用它，但是如果我的软件只有 5、10 或 20Mb，我需要安装大约一个gig 只是为了让用户可以运行它.

Also, one more thing, I see there is an SQL Server express edition, which I can supposedly use in deployment, but it seems kinda heavy knowing that if my software if just 5, 10 or 20Mb I need to install about a gig just so user can run it.

最后，如果我使用的是 SQL Server 2008 Developer Edition(我是，或者不确定是企业版)并且我在客户端上安装了 SQL Server express，如果我的软件使用了一些没有的功能，会不会引起一些问题Express版支持吗?(说数据库的数量，或并发连接，或任何东西).

Lastly, if I am using SQL Server 2008 Developer Edition (which I am, or enterprise one not sure) and I installed SQL Server express on client, wouldn't it cause some problem if my software uses some features that are not supported in express edition? (say number of database, or concurrent connection, or anything).

所以?它需要什么运行时?如果安装 sql server express 是唯一的选择，如果我使用了一些 express 版本不支持的功能怎么办?当然，我不能继续在每个客户端上完全安装开发者版！

So? What runtime is required for it? And if installing sql server express is the only option, what if I am using some features that are not supported in express edition? Surely, I can't go on doing a full install of developer edition on each client!

如果这有任何帮助，我当前的项目是一个图书馆管理系统，它将安装在客户端(我为之制作的图书管理员的计算机)，所以这里没有服务器 - 客户端的情况.那我应该在他的电脑上安装sql express吗?此外，正如 YvesR 在他的回答中指出的那样，该链接仅显示三个版本(主要版本)，但是 http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx 显示了更详细的比较.那么，在我刚刚描述的这个特定场景中，如果我只是在客户端机器上部署和表达版本就足够了吗?

In case this is of any help, my current project is a library management system, and it will be installed the client (the computer of the librarian for whom I am making this), so there is no case of server-client here. So should I install sql express on his computer? Also, as YvesR pointed out in his answer, that link only shows three editions (main ones), but http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx shows more detailed comparison. So, in this particular scenario that I just described, would it be sufficient if I just deployed and express edition on client's machine?

现在，关于我所说的某些功能在 Express 版本中不可用，http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx#CrossBoxScale显示 express 版本仅限于 10Gb 大小的数据库，现在我知道在我上面描述的场景中已经足够了，但是如果在其他一些情况下我需要更多呢?比快递版不行，比我该怎么部署?

Now, about what I said about some functions not being available in express edition, http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx#CrossBoxScale shows that express edition is limited to a database of size 10Gb, now I know that is more than enough in the scenario I described above, but what if in some other case I need more than that? Than express edition won't do it, than how should I deploy?

最后，http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx 显示了另外两个版本，Compact 和 Developer，我知道 developer，但是这个 Compact 版本是什么?更重要的是，为什么这些没有在这里列出或列出?

Finally, http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx shows two more edition, Compact and Developer, I know about developer but what is this compact edition? And more importantly, why are these not comared or listed here?

编辑 2: 它是 4Gb，限制，而不是 10Gb.SQL Server 2008 R2 Express 及更高版本中为 10Gb，SQL Server 2008 Express 中为 4Gb.
marc_s:谢谢！

Edit 2: Its 4Gb, the limit, not 10Gb. 10Gb is in SQL Server 2008 R2 Express and above, 4Gb in SQL Server 2008 Express.
marc_s: Thanks for that!

推荐答案

如果您使用 SQL Server 数据库将数据保存在您的应用程序中，您需要

If you use a SQL Server database to persist your data in your application you need

一个.客户端-服务器基础结构，您的客户端通过 LAN 连接到中央 SQL Server

a. client-server infrastructure where your client connect to a central SQL Server via LAN

B.或者使用客户端安装的 sql server 版本(我猜这就是你想要的).为此，您可以使用 SQL Server Express 版或仅使用 MSDE(桌面版).

b. or use a client installed sql server edition (which is what you want I guess). For this you can use SQL Server Express edition or just a MSDE (Desktop Edition).

查看更多详细信息，例如这篇博文 http://searchsqlserver.techtarget.com/tip/SQL-Server-2005-Express-vs-Desktop-Engine-MSDE 或谷歌搜索，MS 自身提供的关于 MSDE 的大量信息.

See for more details e.g. this blog post http://searchsqlserver.techtarget.com/tip/SQL-Server-2005-Express-vs-Desktop-Engine-MSDE or google for it, plenty of information from MS itself about MSDE.

自 2012 年起不再有 MSDE，但 SQL Server 2012 Express 带来了类似于 MSDE 的模式.请参见此处:http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

Since 2012 there is no more MSDE, but SQL Server 2012 Express brings a mode like MSDE did. See here: http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

正如您在此处看到的:http://www.microsoft.com/sqlserver/en/us/editions.aspx，恕我直言，您使用的功能不应不适用于桌面应用程序.

And as you can see here: http://www.microsoft.com/sqlserver/en/us/editions.aspx, there shouldn't be a function that you use that isn't available for a desktop application imho.

这篇关于如果我的软件使用它，我是否必须在每个客户端上安装 sql server?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！