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

Popular posts from this blog

jquery - How can I dynamically add a browser tab? -

node.js - Getting the socket id,user id pair of a logged in user(s) -

keyboard - C++ GetAsyncKeyState alternative -