Visual studio 2010 and Sql Server

sql-server sql-server-2008 sql-server-2008-express visual-studio-2010
Fitzchak Yitzchaki picture Fitzchak Yitzchaki · Mar 18, 2010 · Viewed 52.9k times · Source

Do visual studio 2010 include already Sql Server instance, or I need to install Sql Server developer edition to develop an application that need a Sql Server db.

If it installs a Sql Server express edition, it this enough or it's better to have Sql Server developer edition?

Answer

realMarkusSchmidt picture realMarkusSchmidt · Mar 21, 2010

I would second that installing the "full" SQL Server Development Edition makes sense if you do serious database development.

However you can have both installed side by side, and having SQL Server Express is very useful for one reason - it supports placing database files in the App_Data folder of ASP.NET applications. While I don't do this for my own projects, it's a very nice feature for demos or open source applications you download from the web: just unzip, start VS, hit F5, and you have a running solution including database. Without SQL Express, you first have to move the MDF file, attach the database, set up user rights, replace the connection strings etc...

Related questions

how to instal MS SQL Server 2008 management studio in windows 8?

I am using 64bit Windows 8 rtm. Where can I get Sql server 2008 mgmt. studio for it?I tried installing sql server 2008 express sp1 and SQL Server 2008 R2 Express SP1, but it wont install.(ref: http://blogs.msdn.com/b/sqlexpress/…

Read More
SQL Server Browser showing only hostname, not instance name

I just setup a new Windows Server 2008 machine with an instance of SQL Server 2008 Express. The SQL Browser service does not appear to be working correctly. In Management Studio, browsing for servers shows the hostname of the new server, but …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More