What is the difference between using the built in SQL Server Database (.mdf) over using sql server management studio? Is there any differences or benefits of using one or the other for say a CMS?
answer was here What is an MDF file?
Asked
Active
Viewed 81 times
0
-
4The question doesn't make sense. sql server management studio is an administration interface. Are you asking about user instance databases? – Martin Smith Mar 21 '11 at 00:35
-
Im talking about the SQL database file you can use in visual studio and edit instead of using sql management studio. The database is in the directory of my website. – Chris Mar 21 '11 at 00:37
-
1You need some very basic lessons on SQL Server, Relational database systems, or both, or more. With all due respect. This cannot be covered in a single question - move to close. – RichardTheKiwi Mar 21 '11 at 00:38
-
@Chris - Yes that's a [user instance database](http://msdn.microsoft.com/en-us/library/bb264564%28v=sql.90%29.aspx). As opposed to a "normal" SQL Server database. Apparently [they are now deprecated](http://stackoverflow.com/questions/5046044/future-of-user-instance-in-sql-server) I've never used them myself I think the advantages (if any) are covered in my first link. – Martin Smith Mar 21 '11 at 00:39
-
thanks martin, exactly what I was looking for. Richard you can keep those comments to yourself. – Chris Mar 21 '11 at 00:44
-
3@Chris: Being rude won't get you help here. Neither will continuing to ask questions without accepting any answers. – Ken White Mar 21 '11 at 01:25
1 Answers
1
Both Visual Studio and SQL Server Management Studio work with the same .mdf files. These are simply the data format files that make up a SQL Server database. SSMS will give you a much more rich set of administration features to help in your database maintenance.
If you are going to be building full system, you will want to begin using SSMS at some point in my opinion. This will give you some easier GUI interface options to work with for administrating.
