.dbo和.mdf数据库之间的区别 [英] difference between .dbo and .mdf database

问题描述

我真的是数据库新手，正在使用Visual Studio2010。据我所知，有两种创建数据库的方法。第一种是右键单击项目，然后选择Add-> New Item，然后在Add New Item对话框中，选择基于服务的数据库，该数据库创建一个位于我的项目本地的mdf文件。

I am really new to database and I am using visual studio 2010. From what I know, there are two ways of creating a database. The first is to right clicked on the project and select Add->New Item and then in the Add New Item dialog I select the Service-based Database which creates a mdf file that lies locally in my project.

或者，我也可以通过以下方式创建数据库。右键单击Server Explorer中的DataConnection，然后选择Create New SQL Server Database。创建的数据库在服务器资源管理器中显示为homepc\sqlexpress.myCreatedDatabase.dbo。

Alternatively, I can also create a database in the following way. Right click on the DataConnection in Server Explorer and select Create New SQL Server Database. The created database is shown in server explorer as homepc\sqlexpress.myCreatedDatabase.dbo.

所以我的问题是，这两个数据库（mdf和dbo）之间有什么区别？

So my question is what is the difference between this two databases (mdf and dbo) and will there be any differences that might occur after I release my project, install and run it on other pcs?

推荐答案

.DBO 是数据库所有者，而


.MDF 是清单数据文件，它是实际的数据库文件。
主数据文件包含数据库的启动信息，并指向数据库中的其他文件。用户数据和对象可以存储在此文件或辅助数据文件中。每个数据库都有一个主数据文件。推荐的主要数据文件扩展名是 .mdf 。（请参见 msdn ）



有关更多信息，请参见论坛 DBO或MDF的区别是什么？

.DBO is the database owner while

.MDF is the manifest data file which is the actual database file. The primary data file contains the startup information for the database and points to the other files in the database. User data and objects can be stored in this file or in secondary data files. Every database has one primary data file. The recommended file name extension for primary data files is .mdf.(see msdn)

for more info see the forum here DBO or MDF whats the diffrence?

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