SQL Server 2005 Express Edition

Discussion in 'Databases' started by fizzydigital, Aug 15, 2005.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Hi All,

    I was thinking of building some web applications using Access. Firstly because I wasn't expecting overly heavy use of the applications, and secondly because I don't want to fork out for extra SQL Server hosting (though I can see why you would if you had a site that was getting a lot of use).

    Anyway, I might be a little behind the times, as this week, I found out about SQL Server 2005 Express Edition, or SQL Server Express for short. For those of you who are even further behind than me, take a look here : http://lab.msdn.microsoft.com/express/sql/default.aspx

    The thing that always worried me about Access, was the potentialpain involved in upgrading an Access DB to a SQL Server DB should the need have ever arised. But to me, with SQL Server Express, it looks like you can throw Access in the bin, and develop on a "lite" version of SQL Server, with, I'm assuming,better performance than Access, and less stress should you ever need more than a single processor or 1Gb of RAM to handle the DB.

    Is this too good to be true? Have I missed something? Has anybody tried SQL Server Express yet? What is the meaning of life?

    Any thoughts gratefully recieved.
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    SQL Server Express 2005 is a new version of MSDE which is a toned downed version of MS SQL 2005.

    SQL Server express 2005 is designed to be a development database with a lot of performance and advanced features of SQL 2005 removed.

    Like MSDE, we recommend customer develop in SQL Express in their local environment and upload the DB to our SQL server. This way, you do not have to pay for the hefty price on SQL 2005.

    For your need, you probably want to start out with MS Access.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page