RE: SQL 2008 standard vs. web
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 SQL Engine and into SSIS, SSAS, and SSRS. Full comparison of all editions here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Regards -- Russ Michaels www.cfmldeveloper.com - free CFML hosting for developers my blog: http://russ.michaels.me.uk/ skype: russmichaels ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340475 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL 2008 standard vs. web
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 differences will be in the cost and licensing (how many CPUs, memory it can use, etc.). My understanding is that the Web edition is targeted at larger web hosting companies that need to offer SQL server as a back-end, or for larger single customers who have a large web infrastructure. It is only available under a volume licensing plan, so if you just want one copy you're likely better off purchasing standard (assuming that SQL Express doesn't meet your needs for free). -Justin ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340476 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL 2008 standard vs. web
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 version based on what I've read but first hand feedback is best. If you're just setting up a standalone web application, the Web edition will work fine. If you need replication, mirroring, etc, you need at least Standard. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340477 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL 2008 standard vs. web
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 version and switch to the more expensive version later on, unless there is a feature of the Standard version that you know is essential, such as the disaster recovery features that only exist in the more expensive versions. -Mike Chabot On Wed, Jan 5, 2011 at 2:16 PM, Michael Dinowitz mdino...@houseoffusion.com wrote: 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 version based on what I've read but first hand feedback is best. Thanks Michael ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
