在SQL Server防爆preSS的ASP.NET MVC Web应用程序数据库维修 [英] Is SQL Server Express a serviceable database for a ASP.NET MVC web application

问题描述

我即将开始建设依赖，因为它的后端（大惊喜）的数据库在ASP.NET MVC Web应用程序。

I am about to start building a ASP.NET MVC web application that relies on a database as it's backend (big surprise).

作为一名学生，我有机会（通过的DreamSpark）到SQL Server 2008开发版，并使用默认的VS 2008安装，我的SQL Server防爆preSS 2005年已安装。

As a student, I have access (via Dreamspark) to SQL Server 2008 Developer Edition, and with the default VS 2008 install, I have SQL Server Express 2005 installed already.

很多我见过使用本地密度纤维板（SQL数据库）作为后端的MVC的例子。

Many of the examples on MVC I have seen use a local .mdf (SQL database) as their backend.

我的问题是：

我应该使用最初的开发和设计的本地数据库文件？ （SQL Server的防爆preSS）或者我应该安装2008开发版，并使用一个正确的数据库，而不是？

Should I use a local database file for initial development and design? (SQL Server Express) or should I install the 2008 dev edition and use a "proper" database instead?

这是我的最后的打算推出一个公共网站的应用程序，所以我希望建立的。

This is an application that I eventually intend to launch as a public site, so I'm looking to build for that.

推荐答案

在开始使用开发版之前，你需要知道它是什么，什么样的限制使用它是你。

Before you start using the Development edition, you need to be aware what it is and what the limitations are of you using it.

SQLEx preSS是使用完全正常，无论是开发，当你发布你的产品。它具有相同的引擎SQL标准，但在地方一对夫妇的限制，比如4GB的最大文件大小（我认为它也有一个内存的限制，但不知道在那一个）。你被允许使用SQL防爆preSS作为后端为您的网站，没有额外的授权费用（即 - 免费的）。我在那里工作了链接SQL防爆preSS的几个实例在一起的制度只是为了让轮4GB文件限制一个地方的工作 - 但请注意，这可能违反了它的许可证

SQLExpress is perfectly fine for using, both for dev and when you release your product. It has the same engine as SQL Standard, but with a couple restrictions in place, such as a max file size of 4GB (and i think it also has a RAM limit, but not sure on that one). You are allowed to use SQL Express as the backend for your website with no extra licencing costs (i.e. - free). I have worked at one place where they worked out a system of chaining several instances of SQL Express together just to get round the 4GB file limit - but be aware that this may contravene the licence of it.

SQL开发人员实际上是SQL企业，但没有在OS安装时间限制。您还不允许使用SQL Developer的生产（即对您的现场应用程序）。对于任何你美元SQL Developer的C $ C也可以执行的SQL前preSS你必须要小心，不要使用任何的企业功能的用途，但 - 许可的企业可以是一个昂贵的选项

SQL Developer is actually SQL Enterprise, but without the install time restriction on OS. You are also not permitted to use SQL Developer in production (i.e. for your live app). For most purposes whatever you code on SQL Developer can also execute on SQL express, but you have to be careful not to use any of the Enterprise features - licencing Enterprise can be a pricey option.

所以，继续使用SQL防爆preSS，这是一个不错的选择。

So go ahead and use SQL Express, it is a good option.

P.S。 - 我假设你的数据库也不会高负载 - 如果是，那么你就需要考虑标准或企业版

P.S. - i am assuming that your database won't be high load - if it is then you would need to consider either Standard or Enterprise.

这篇关于在SQL Server防爆preSS的ASP.NET MVC Web应用程序数据库维修的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！