SQL 2008 standard vs. web

2011-01-05 Thread Michael Dinowitz
There are a few different versions of SQL 2008. One of them is billed as SQL server web which is focused on being the backend for a data driven website. Has anyone used this and have they had any problems? Any real differences between this and SQL 2008 standard? I'm inclined to go with the web

RE: SQL 2008 standard vs. web

2011-01-05 Thread Russ Michaels
They're close, but not quite the same. The primary difference is the licensing . The other differences are around mirroring (web can only serve as a witness), publishing (web can only subscribe), and perf (web does not come with SQL Profiler). There are more differences when you get out of the

RE: SQL 2008 standard vs. web

2011-01-05 Thread Justin Scott
There are a few different versions of SQL 2008. One of them is billed as SQL server web which is focused on being the backend for a data driven website. Has anyone used this and have they had any problems? The engine itself should be essentially the same between editions, the main

Re: SQL 2008 standard vs. web

2011-01-05 Thread Dave Watts
There are a few different versions of SQL 2008. One of them is billed as SQL server web which is focused on being the backend for a data driven website. Has anyone used this and have they had any problems? Any real differences between this and SQL 2008 standard? I'm inclined to go with the

Re: SQL 2008 standard vs. web

2011-01-05 Thread Mike Chabot
A primary question to answer is whether you need the business intelligence tools that are part of the SQL Server platform, notably SSIS, which is not available in the Web edition. I use SSIS and SSRS extensively, so I have to use at least the Standard edition. You can always start with a cheap