difference between .dbo and .mdf database -
i new database , using visual studio 2010. know, there 2 ways of creating database. first right clicked on project , select add->new item , in add new item dialog select service-based database creates mdf file lies locally in project.
alternatively, can create database in following way. right click on dataconnection in server explorer , select create new sql server database. created database shown in server explorer homepc\sqlexpress.mycreateddatabase.dbo.
so question difference between 2 databases (mdf , dbo) , there differences might occur after release project, install , run on other pcs?
.dbo database owner while
.mdf manifest data file actual database file. primary data file contains startup information database , points other files in database. user data , objects can stored in file or in secondary data files. every database has 1 primary data file. recommended file name extension primary data files .mdf.(see msdn)
more info see forum here dbo or mdf whats diffrence?
Comments
Post a Comment