什么是SQL Server的用户实例，使他们无法在非Express版？ [英] What are in SQL Server User Instances that make them impossible in non-Express Editions?

问题描述

几年（或更多）开发之后，我还是不明白：

After developing for a few years (or more), I still do not understand:

• 是什么让用户实例是不可能的/不兼容开发者（或任何其他）的SQL Server版？结果
  
  
  
  • 为什么开发商的SQL Server安装多个（即开发版），因为用户实例仅可用通过易捷版？
  
  

  更新：@Damien_The_Unbeliever在他的回答中写道，

  Update: @Damien_The_Unbeliever wrote in his answer,

  的用户实例很好有望成为独立的数据库，仅由单个应用程序，以及毫无意义的该应用程序。

  我是否理解正确的用户实例：

  Do I understand correctly that user instances:

  
  
  • 需要SQL Server Express安装
  
  
  • 不能远程连接
  
  
  • 的用户不能有多个这样的实例？
  
  
  • 连接到它们的客户端应用程序都喜欢VS，SSMS，WebAdmin的，的 SQL Express的工具等？
  
  
  • require SQL Server Express setup
  • cannot be connected remotely
  • the user cannot have more than one such instance?
  • the client apps that connect to them are dev tools like VS, SSMS, webadmin, SQL Express Utility, etc?

  我真的不明白当/为什么/如何将它们用于/部署开发环境之外

  Really I do not understand when/why/how they can be used/deployed outside of development environment

  的什么是SQL Server的用户实例的非-dev的情况下（与CE等嵌入式数据库）？

  推荐答案

  我不认为有，为什么用户实例功能，不能在其他版本存在任何技术上的原因 - 但非Express版代表了不同形式的预期使用的

  I don't believe that there are any technical reasons why the user instance functionality couldn't exist in the other editions - but the non-express editions represent a different form of expected usage.

  用户实例很好预计是独立数据库，仅由一个单一的应用程序，并且无意义没有这种应用

  User instances are pretty well expected to be standalone databases, only used by a single application, and meaningless without that application.

  在标准版/企业版数据库预计将维持（可能是由专门的DBA）作为独立的资源，以维护计划，调度作业，等他们一定会使用这些版本的附加功能，它是没有意义单个应用程序来控制这些数据库的可用性。

  Databases under Standard/Enterprise edition are expected to be maintained (possibly by dedicated DBAs) as standalone resources, with maintenance plans, scheduled jobs, etc. They're expected to use additional features of these editions, and it wouldn't make sense for a single application to control the availability of these databases.

  和作为一个开发者，你只需要，如果你同时安装再努力，其中两种用法意义系统 - 与简单的数据需求都建设小规模的网站，并且需要更复杂的数据库系统更大的系统。

  And as a developer, you only need both installed if you're working on systems in which both usages make sense - both building small scale websites with simple data requirements, and larger systems that need more complex database systems.

  这将使用用户实例，而不是作为一个开发工具，应用程序的典型的例子，将是一个小型Web应用程序。它可具有一个或多个MDF文件，在它的App_Data文件夹。它可以从这样的数据库运行等服务，其会员制度。这样的设置的优点是，这样一个网站的一个的XCopy部署足够用于整个应用程序做好准备。 - 连接字符串将立即有效

  The "typical" example of an application that would use a user instance, but not being a dev tool, would be a small web application. It may have one or more mdf files in it's App_Data folder. It may run such services as its membership system from such a DB. An advantage of such a setup is that an XCopy deploy of such a website is sufficient for the entire application to be ready - the connection string will be valid immediately.

  这篇关于什么是SQL Server的用户实例，使他们无法在非Express版？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！