What can you do in SQL Server 2008 Standard Edition that you cannot do in SQL Server 2008 Web Edition?
I've seen the Microsoft feature lists, but I am wondering from a very practicle standpoint where I am going to run into limitations.
A:
http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
Edit: Sorry, you've probably already looked at the above.
aidan
2009-02-26 22:46:37
+7
A:
Have you seen this matrix as well?
http://msdn.microsoft.com/en-us/library/cc645993.aspx
From what I can tell Web excludes a lot of the more advanced features, especially those related to development and data mining, but nothing that would stop you from using it for a non-enterprise web site's data source. It seems to be between the Express version and Standard version.
metanaito
2009-02-26 22:49:58
+3
A:
One of the biggest limitations is that it can't be a publisher for SQL replication. If you want to have multiple database and replication data between them, then you need at least one SQL server to be Standard or Enterprise to act as the publisher.
Jesse Weigert
2009-02-26 22:50:05
"biggest limitations" is probably over stating it. MS's implementation of Replication leaves a lot to be desired.
Chris Lively
2009-02-26 22:56:49
+1
A:
One of the main things for me is the lack of SQL Agent. Which means you can't schedule jobs to run.
Chris Lively
2009-02-26 22:57:29
Per the feature matrix, Web Edition DOES have Agent. What version are you referring to?
Oskar Austegard
2010-03-04 17:39:39
@Oskar: Well, that would be the express edition which, obviously, the OP wasn't talking about ;)
Chris Lively
2010-03-04 18:42:45