54

Is there any technical difference between these 2 editions or is it just how they are licenced?

Shiraz Bhaiji
  • 2,219
  • 8
  • 34
  • 47

3 Answers3

42

Since newer version(s) of SQL Server have been released, the feature comparison is tucked away in MSDN:

ihebiheb
  • 103
  • 4
Jim Geurts
  • 657
  • 1
  • 9
  • 13
32

Here you can find a comprehensive comparison :

http://msdn.microsoft.com/en-us/library/cc645993%28SQL.105%29.aspx

Please note: the Web edition does come with SQL Profiler and management studio

  • 8
    [The Web edition 2012 and 2014 don't come with SQL Profiler anymore.](http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx) – user220388 May 20 '14 at 13:04
22

They're close, but not quite the same. The primary difference is the licensing (as you mention). The other differences are around mirroring (web can only serve as a witness), publishing (web can only subscribe), and performance (web does not come with SQL Profiler).

There are more differences when you get out of the SQL Engine and into SSIS, SSAS, and SSRS.

Full comparison of all editions here

masegaloeh
  • 17,978
  • 9
  • 56
  • 104
Sean Earp
  • 7,207
  • 3
  • 34
  • 38