SQL Server 2008 is divided into SQL Server 2008 Enterprise Edition, Standard Edition, Workgroup Edition, Web Edition, Developer Edition, Express Edition, Compact 3.5 Edition, and its functions and functions vary, with SQL Server 2008 Express Edition is a free version.
SQL Server 2008 Enterprise Edition
SQL Server 2008 Enterprise Edition is a comprehensive data management and business intelligence platform that provides enterprise-class scalability, data warehousing, security, advanced analytics, and reporting support for business-critical applications. This version will provide you with a more robust server and perform large-scale online transaction processing. This is the most bull B version.
SQL Server 2008 Standard Edition
SQL Server 2008 Standard Edition is a complete data management and business intelligence platform that provides the best ease of use and manageability features for departmental applications.
SQL Server 2008 Workgroup Edition
SQL Server 2008 Workgroup Edition is a trusted data management and reporting platform for secure publishing, remote synchronization, and management of running branch applications. This version has core database features that can be easily upgraded to standard or Enterprise editions.
SQL Server Web Edition
SQL Server Web Edition is designed for environments running on Windows servers that require highly available, Internet-facing Web services. This release provides the necessary support tools for implementing low-cost, large-scale, high-availability Web applications or customer-managed solutions.
SQL Server 2008 Developer Edition
The SQL Server 2008 Developer Edition allows developers to build and test any type of SQL Server-based application. This version has all the features of the Enterprise Edition, but is limited to use in development, testing, and presentation. Applications and databases developed based on this version can be easily upgraded to the Enterprise Edition.
SQL Server Express Edition
SQL Server Express Edition is a free version of SQL Server that has the core database functionality, including the most recent data type in SQL Server 2008, but it is a miniature version of SQL Server. This version is published for learning, creating desktop apps and small server applications, and is also available for ISV Redistributable.
SQL Server Compact version 3.5
The SQL Server Compact is a free embedded database designed for developers with the intention of building a standalone mobile device, desktop, and Web client application with only a small number of connectivity needs. The SQL Server Compact can run on all Microsoft Windows platforms, including Windows XP and Windows Vista operating systems, as well as Pocket PC and Smartphone devices.
Differences in SQL Server 2008 editions (includes Enterprise Developer Edition Standard version of the Web Workgroup Express Edition Compact Edition)