SQL Server 2008 R2 Editions Overview
SQL Server R2 Core Editions
SQL Server 2008 R2 offers expanded functionality and innovation across the most popular editions, Enterprise and Standard.
SQL Server 2008 R2 Specialised and Breadth Editions
SQL Server 2008 R2 continues to deliver both specialised and broad-reaching editions to meet the unique needs of our customers.
Web
Designed specifically for service providers that host websites and web applications, and for organisations that host their own websites and applications, Web Edition offers an optimal balance of scalability and manageability at an affordable price.
Workgroup
A reliable data management and reporting platform that delivers highly secure, remote synchronisation and management capabilities for running branch applications.
Developer
Enables developers to build and test applications that run on SQL Server on 32-bit, ia64, and x64 platforms. Developer includes all of the functionality of Datacenter but is licenced only for development, test and demo use.
Express – FREE
Microsoft SQL Server 2008 R2 Express is a free edition of SQL Server that is ideal for learning, for developing and powering desktop, web and small server applications, and for redistribution by ISVs.
Compact – FREE
Microsoft SQL Server 2008 R2 Compact is a free SQL Server embedded database ideal for building standalone and occasionally connected applications for mobile devices, desktops, and web clients.