sdf和mdf之间的区别？ [英] Difference between sdf and mdf?

问题描述

我正在使用Visual Studio 2010，但对于b / b mdf基于服务的数据库和sfd本地数据库的差异和功能感到困惑。我应该选择什么作为我的项目

以及在Visual Studio中使用C＃部署项目的最佳方法是什么？

I am working with Visual Studio 2010 but am confused by the differences and functionality of
mdf "service based database" and sfd "local database. What should I choose as my project
and what is the best way to deploy project with C# in Visual Studio?

推荐答案

这取决于项目。

简而言之：

SDF：它是 SQL Server Compact Edition的数据库格式 [ ^ ]。是sql server的嵌入式版本。把它想象成一个单dllsql服务器。因此它将与使用它的应用程序一起运行。它不是服务，它不是真正的服务器。但是如果你的数据库是从单个应用程序（甚至是多用户的Web应用程序）访问的，这是一个很好的方法，虽然它有一些限制。

MDF：t他是大真实服务器版本的数据库格式。你使用哪一个（从快递到数据中心），这就是格式。但它取决于许多事情，你需要/可以使用哪个版本 - 其中一个是你愿意支付的金额:)。请参阅这个简短而全面的版本比较图表： http://www.sqlserverspace.com/sqlservereditioncomparison.html [< a href =http://www.sqlserverspace.com/sqlservereditioncomparison.htmltarget =_ blanktitle =New Window> ^ ]，如果您需要更多详细信息，请执行以下操作：http://msdn.microsoft.com/en-us/library/cc645993.aspx [ ^ ]

It depends on the project.
To be short:
SDF: it is the database format of SQL Server Compact edition[^]. This is the embedded edition of sql server. Think about it as a "single-dll" sql server. Thus it will run together with the application that is using it. It is not a service, it is not a real server. But if your database is accessed from a single application (even a web application that is multi-user), this is a good approach, although it has some limitations.
MDF: this is the database format of the "big", real server editions. Indifferent which one you use (from express to datacenter), this is the format. But it depend on many things, which edition you need/can use - one of this things is the amount of money you are willing to pay :). Please see this really short and comprehensive edition comparsion chart: http://www.sqlserverspace.com/sqlservereditioncomparison.html[^], and this if you need more details: http://msdn.microsoft.com/en-us/library/cc645993.aspx[^]

这篇关于sdf和mdf之间的区别？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！