Geek Answers Handbook

Visual Studio 2010 and Sql Server

Visual Studio 2010 already includes an Sql server instance, or I need to install the Sql Server developer version to develop an application that requires an Sql SQL server.

If he installs the express version of Sql Server, is it enough or better to have a version of the Sql Server developer?

+6
sql-server sql-server-2008 visual-studio-2010 sql-server-2008-express
source share
3 answers

I would say that installing the “full” version of SQL Server Development Edition makes sense if you are seriously developing the database.

However, you can install both side by side, and SQL Server Express is very useful for one reason - it supports placing database files in the App_Data application's App_Data folder. Although I do not do this for my own projects, it is a very nice feature for demos or open source applications that you download from the Internet: just unzip, launch VS, press F5, and you have a working solution, including a database. Without SQL Express, you first need to move the MDF file, attach the database, configure user rights, replace connection strings, etc ...

+11
source share

Visual Studio 2010 installer gives you the option to install SQL Server 2008 Express Edition. This release of SQL Server is good enough for development purposes, but not intended for production use.

+7
source share

I think size limitation is not the main issue. In Sql Server 2008, you have some features in Sql Server Management Studio that are not available in Express Management Studio or in the Express database, for example: - offering table and column names (in the query window) - Sql Profiler Cor Vestra

+2
source share

More articles:


All Articles