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 |
|
pingwee
Starting Member
2 Posts |
 Posted - 2006-07-13 : 16:36:56
|
| Hi,I am currently developping an ASP.NET site using SQL Express as database.Planning to publish it on a server very soon, will I be able to use SQL Express on my server ? Was is the main difference with other versions ?I was suprised to see that it SQLEXPRESS I am able to place database files in a App_Data folder, whereas on older versions everything was centralised in the MSSQL folder. Could someone explain me this change ? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-13 : 16:41:47
|
| You can put your database files in any folder that you want. It doesn't have to go in the MSSQL folder in older versions, that's just the default. You need to look at the SQL Express features to determine if it's what you want on your server:http://www.microsoft.com/sql/editions/express/default.mspxTara Kizer |
 |
|
|
pingwee
Starting Member
2 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-07-14 : 12:30:52
|
| That isn't its only limitation. We require Enterprise Edition for our environments. None of the other editions have the features that we need. So it just depends on what you need.Tara Kizer |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2010-11-21 : 17:40:49
|
| asp.net supports you using sql server in two ways.To rival mysql you can do it the way you are currently doing it.The better way, is to install sql on the server and make a reference via a class data set to you database.there are loads of tutorials and videos herehttp://www.asp.net/get-started |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Express and ASP.NET