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)
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.
Does SQL Server 2008 Express with Advanced Services include Service Pack 1?
@nemoluca,
Nope.
It is always recommended you install advanced services and install the Service pack.
Thanks
whats the difference between SQL2008 express R2 SP1 and SQL Codename Denali? which is better?