SQL server2008 R2 differences and choices for each version

The currently known versions of SQL Server R2 are: Enterprise, Standard, Workgroup, web, Developer, Express, Compact version 3.5 .

This order is also a sort of the power of each version of the feature from high to low. Which version to use, not about the stronger the better, but should use the appropriate version. Many junior developers, such as me, are often not very clear about the specific meanings of these versions, so I'll summarize the highlights of what I've seen today from a few posts. Hope to the later of the time on the savings, less detours.

1, seven versions of the specific meaning [1]

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.

2, the version of the selection guide

In addition to choosing according to the requirements, I would also like to say that for developers, the development of testing, select the development version, the deployment of the Enterprise version. and the general choice of Express version can meet the common needs.

3. Download and install

Chinese version [2]:

Version 32 of SQL Server R2

Version 64 of SQL Server R2

The same can be used, the first 32-bit No. 264 bit

When installing, remember to select the client, or no Enterprise Manager is too troublesome, and not as good as 05, so the installation of the best way to bring

SQL Server R2 serial number
=========================================
Sql. Server.2008.r2_sn
=========================================

Data Center Edition: PTTFM-X467G-P7RH2-3Q6CG-4DMYB
Ddt3b-8w62x-p9jd6-8mx7m-hwk38
=========================================

Enterprise Edition: R88PF-GMCFT-KM2KR-4R7GB-43K4B
Gyf3t-h2v88-grpph-hwrjp-qrtyb
=========================================

Standard Edition: Cxtft-74v4y-9d48t-2dmfw-tx7cy
B68q6-kk2r7-89wgb-6q9kr-qhfdw
=========================================

Development version: MC46H-JQR3C-2JRHY-XYRKY-QWPVM
ftmgc-b2j97-pj4qg-v84yb-mtxx8
=========================================

Working Group Edition: Xq4cb-vk9p3-4wyyh-4hqx3-k2r6q
=========================================

Web version: Fp4p7-ykg22-wgrvk-mkgmx-v9mtm
=========================================

Reference articles

1. The endless, SQL Server2008 Enterprise Edition and Standard Edition , 2013-9.

2. Ducky, SQL Server R2 RTM (32&64) Chinese version & serial number , 2011-5.

SQL server2008 R2 differences and choices for each version