50

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

31

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

39

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

  • 2
    Any chance we could get a link for SQL Server 2017? – Cullub May 23 '18 at 17:48
21

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.