SQL SERVER – Choose Right Edition of SQL Server Express for Your Application

SQL Server Express is better alternative of MySQL. I have recently helped quite a few organizations to move to SQL Server Express recently. However, one question keep on coming up quite often regarding which is the right edition for SQL Server Express. SQL Server Express have more than one edition available.

Here is the quick guide to select right edition for SQL Server.

After reading above guide if you are still not sure which edition you should select, leave a comment here or send me email and I will get back to you.

SQL Server 2008 Express with Advanced Services – 546.6 MB

  • SQL Server Database Engine
  • SQL Server Management Studio Basic
  • Full-Text Search
  • Reporting Services

SQL Server 2008 Express With Tools – 230.4 MB

  • SQL Server Database Engine
  • SQL Server Management Studio Basic

SQL Server 2008 Express Runtime Only – 82.5 MB

  • SQL Server Database Engine

SQL Server 2008 Express Management Studio Basic – 38.5 MB

  • SQL Server Management Studio Basic

SQL Server 2008 Management Studio Express is also known as SSMSE.

You can refer my complete reference article SQL SERVER – SQL Server Express – A Complete Reference Guide.

Reference: Pinal Dave (https://blog.sqlauthority.com)

, ,
Previous Post
SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition
Next Post
SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER

Related Posts

4 Comments. Leave new

  • Its good to know that express edition with advanced services also supports reporting services. I will further look at reporting server capabilities there.
    Thanks for sharing this info.

    Reply
  • Does SQL Server 2008 Express with Advanced Services include Service Pack 1?

    Reply
  • @nemoluca,

    Nope.

    It is always recommended you install advanced services and install the Service pack.

    Thanks

    Reply
  • whats the difference between SQL2008 express R2 SP1 and SQL Codename Denali? which is better?

    Reply

Leave a Reply

Menu