• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

Regarding the SQL Server Express Edition

we are Developing a web application in dotnet with backend of sqlexpress 2005.Express edition  is a freeware downloaded from microsoft website.I have a doubt regarding this. whether it is used for our company purpose to store our data into a database through a web application developed by our company members.only one website will run to insert data.may be more than thousand members will use this site to store data into database.But it is a centralised database and will be located in one cpu only.can express edition is used for this purpose? or we have to buy any other version of sql?
0
norton127
Asked:
norton127
3 Solutions
 
reb73Commented:
No, Express edition should not be used as a backend for commercial purposes and besides there are limits (e.g. 2GB max size per database) which may affect the functioning in the long run..

It is more a case of it should not be used rather than cannot be used really..
0
 
norton127Author Commented:
Thank you Reb73 . Presently data base size  is not more than 12mb. I think it will not more than 400MB of database.In this manner can it be used for this purpose. We ar using it for testing purpose.If the employee fell free with this application later on we will purchase the next version.
if not it is used what the next version to be purchased for our purpose and please suggest me its availabily to purchase and how much cost it will be?
         Thank you for your suggestion.
0
 
reb73Commented:
Review the link below to get an idea of what would suit your requirements -

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx?PHPSESSID=0324345d45ef1bf1f764044e03584cd0

Use the How to buy link in the page above to get an idea of pricing for your geographical region..
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
ati_ozgurCommented:
Think about this way, Express editions of all databases, Sql Server, Oracle and DB2 are rival to MySql, PostgreSQl and other open source, hence free databases.

I suggest that use Express edition and if you find its performance acceptable, with 400 mb I am sure you will find it so. If your database and system grows you may upgrade first standart edition. There are a lot of editions of SQL Server you may use. But your application is very suitable for it. If you application uses connection pooling, client number does not matter very much.
0
 
shakashicoCommented:
look we had a same situation in our company but I think less numbers of users .
it's working fine for about 6 month now .
I think you will have no problems
0
 
norton127Author Commented:
Thank you guys for your answers. I am not accepting any ones solution as accept solution because all are right in their way and at some situation all are right. Thank you for your answers. So please forgive me for this situation.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now