对于客户端，sqlserver我必须提供哪一个 [英] For client, sqlserver which one I have to give

问题描述

我正在使用sqlserver2016和visual studio 2015社区。我怀疑是哪个sqlserver我必须给客户。



我尝试过的事情：



我用谷歌搜索，但清晰度不适合我。

I am using sqlserver2016 and visual studio 2015 community. My doubt is which one of sqlserver I have to give clients.

What I have tried:

I googled but clarity not came for me.

推荐答案

您不应该在安装中包含SQL Server。有几个原因：

0）您只能出于版权原因分发SQL Server Express - 而不是SQL Server完整版。

1）他们可能已经拥有SQL Server安装在网络上。如果是这样，那么他们可能会想要使用该版本。

2）如果他们确实安装了SQL服务器并且你开始扩散SQL服务器Express实例，那么你将会惹恼数据库管理员...

3）SQl Server的单站点安装比用户控制下的一些分散版本更有可能被备份。

4）对于普通用户来说，安装和管理Sql服务器非常复杂 - 这不是一个好主意！

5）它将破坏使用Sql Server而不是SqlCE或SQLite的主要优势 - 多用户访问。如果每个人都安装了自己的SQL服务器副本，那么您将拥有数据库的多个副本，每个副本由一个人使用。这会引起一些混乱，并且（取决于你如何编写原始数据库）在实现问题时可能需要付出相当大的努力才能组合成单个实例。



如果您必须使用多用户系统，那么客户端应该自己安装SQL Server（或者您为它们接管数据库管理员并自行安装） - 请记住SQL Server不是一个便宜的产品： SQL Server定价许可| Microsoft [ ^ ]除非您想支付自己的费用吗？



如果您不需要多个用户访问您的数据库，请将您的代码切换为像SQLite这样的单用户数据库引擎 - 甚至是Access - 它们不需要高于你的应用程序所需的特殊安装。

You should not include SQL Server in your installation. There are a couple of reasons:
0) You can only distribute SQL Server Express for copyright reasons - not SQL Server full version.
1) They may already have SQL Server installed on the network. If so, then they will presumably want to use that version.
2) If they do have SQL server installed and you start proliferating SQL server Express instances, you are going to annoy the heck out of the database administrator...
3) A single site installation of SQl Server is a lot more likely to be backed up than a number of scattered version under user control.
4) Sql server is quite complex for a "normal" user to install and administer - it is not a good idea!
5) It will destroy the primary advantage of using Sql Server over SqlCE or SQLite - multiuser access. If everyone installs their own copy of SQL server, then you will have multiple copies of your database, each used by a single person. This will cause some confusion, and (depending on how you wrote the original database) may take some considerable effort to combine into a single instance when the problem is realized.

If you must use a multiuser system, then the client should install SQL Server themselves (or you take over DB admin for them and do the installation yourself) - remember that SQL Server is not a cheap product: SQL Server—Pricing an Licensing | Microsoft[^] unless of course you want to pay for ityourself?

If you don't need multiple users accessing your database, then switch your code to one of the single user DB engines like SQLite - or even Access - which require no special installation above that required by your application.

你可以'给'你的客户唯一的SQL服务器就是快递版本...

您可以选择LocalDB或Express，但任何其他版本都需要花钱，而且您无法放弃它们......

The only SQL server you can 'give' to your clients is the express edition...
It may be LocalDB or Express as you choose, but any other editions are cost money and you can not 'give' them away...

这篇关于对于客户端，sqlserver我必须提供哪一个的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！