Regarding the SQL Server Express Edition

Posted on 2009-02-11
Last Modified: 2012-05-06
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?
Question by:norton127
    LVL 25

    Expert Comment

    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..

    Author Comment

    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.
    LVL 25

    Assisted Solution

    Review the link below to get an idea of what would suit your requirements -

    Use the How to buy link in the page above to get an idea of pricing for your geographical region..
    LVL 4

    Assisted Solution

    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.
    LVL 3

    Accepted Solution

    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

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    New Relic: Our company recently started researching several products to figure out what were the best ways for us to increase our web page speed and to quickly identify performance problems that we may be having. One of the products we evaluated wa…
    Introduction A frequently used term in Object-Oriented design is "SOLID" which is a mnemonic acronym that covers five principles of OO design.  These principles do not stand alone; there is interplay among them.  And they are not laws, merely princ…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now