Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Edition Help

Author  Topic 

William ONeil
Starting Member

1 Post

Posted - 2015-04-20 : 10:32:47
I have been using SQL Server 2008 R2 Standard via my current hosting provider. We are moving to a new host - and they offer licenses for both STANDARD and WEB (SQL Server 2014.)

I'm having a hard time understanding the "real world" difference between the 2 editions. The monthly cost is significant between the two - is there any reason I would need STANDARD over WEB? My DB server doesn't have more RAM than WEB supports and the only differences I see beyond that are REPLICATION related (or possibly related to the use of Profiler.)

Thanks to anyone that can help.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-20 : 14:13:25
check here: https://msdn.microsoft.com/en-us/library/cc645993.aspx
for a comprehensive list.

among other things: no SSIS designer, no compressed backups. other stuff
Go to Top of Page
   

- Advertisement -