Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkatvamsi2003
Starting Member
4 Posts |
 Posted - 2008-10-05 : 01:52:02
|
| i need a database for asp.net projects so which one should i go for sqlexpress 2005 or sqldeveloper or sqlserver management studio. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-05 : 01:55:27
|
| Management studio is the development environment for all MS SQL 2005 and above.Developer is the best choice, as it has all the tools of enterprise, and the other server editions, which your site will run on. However, its not free cost about $50. Express is free, with limited tools. And with express, you can either use a connection string in your web.config file or simply add a .mdf file in your app_data folder. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-05 : 02:21:35
|
| you can compare features of various editions of sql server and then decide what you really want by refering to link belowhttp://www.microsoft.com/sql/prodinfo/features/compare-features.mspx |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-05 : 02:39:30
|
quote:
Originally posted by visakh16
you can compare features of various editions of sql server and then decide what you really want by refering to link belowhttp://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
For asp.net You will be running a development environment and the only two versions that run on a development environment are Express and developer. |
|
|
|
venkatvamsi2003
Starting Member
4 Posts |
Posted - 2008-10-05 : 08:39:33
|
| should i have sql express to installed to work with sql express management studio. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-05 : 08:51:46
|
| yup first install sql server 2005 express and then sql management studio express.more details herehttp://www.aspdotnetstorefront.com/MANUAL/html/installing_sql_server_2005_expre.htm |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-05 : 09:39:16
|
| Yeah,You can always add a database to your work envrionment in VStudio in the database panel on the top right hand corner. You can either add a connection string and build your db directly or you can add a .mdf file in the app_data folder.see this www.asp.net/learnhttp://www.asp.net/learn/data-videos/http://www.asp.net/learn/sql-videos/ |
|
|
|
|
|
|
install