Specialized Editions of SQL Server 2008
Specialized editions of SQL Server 2008 are engineered for specific customer scenarios. The following table describes these editions of SQL Server 2008:
|
Term
|
Definition
|
|---|
|
SQL Server 2008 Developer (x86, x64, and IA64)
|
SQL Server 2008 Developer lets developers build any kind of application on top of SQL Server. It includes all the functionality of SQL Server 2008 Enterprise, but is licensed for use as a development and test system, not as a production server. SQL Server 2008 Developer is an ideal choice for people who build and test applications. You can upgrade SQL Server 2008 Developer for production use.
|
|
Workgroup (x86 and x64)
|
SQL Server Workgroup is ideal for running branch location databases providing a reliable data management and reporting platform that includes secure, remote synchronization and management capabilities.
|
|
Web (x86, x64)
|
SQL Server 2008 Web is a low total-cost-of-ownership option for Web hosts and Web sites that provide scalability and manageability capabilities for small to large scale Web properties.
|
|
SQL Server Express (x86 and x64)
SQL Server Express with Tools (x86 and x64)
SQL Server Express with Advanced Services (x86 and x64)
|
The SQL Server Express database platform is based on SQL Server 2008. It is also a replacement for Microsoft Desktop Engine (MSDE). Integrated with Visual Studio, SQL Server Express makes it easy to develop data-driven applications that are rich in capability, secure in storage, and fast to deploy.
SQL Server Express is free and can be redistributed by ISV's (subject to agreement). SQL Server Express is ideal for learning and building desktop and small server applications. This edition is the best choice for independent software vendors, non-professional developers, and hobbyists building client applications. If you need more advanced database features, SQL Server Express can be seamlessly upgraded to more sophisticated versions of SQL Server.
|
|
Compact 3.5 SP1 (x86)
Compact 3.1 (x86)
|
SQL Server Compact 3.5 is a free, embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops, and Web clients on all Windows platforms.
|
For more information about the specialized editions of SQL Server 2008, see the SQL Server Web site.
Using SQL Server with an Internet Server
On an Internet server, such as a server that is running Internet Information Services (IIS), you will typically install the SQL Server client tools. Client tools include the client connectivity components used by an application connecting to an instance of SQL Server.
.gif) Note: |
|---|
|
Although you can install an instance of SQL Server on a computer that is running IIS, this is typically done only for small Web sites that have a single server computer. Most Web sites have their middle-tier IIS systems on one server or cluster of servers, and their databases on a separate server or federation of servers. For more information about software requirements for SSRS, see Hardware and Software Requirements for Installing SQL Server 2008. For more information about federations, see the Federated Database Servers topic in SQL Server Books Online.
|
Using SQL Server with Client/Server Applications
You can install just the SQL Server client components on a computer that is running client/server applications that connect directly to an instance of SQL Server. A client components installation is also a good option if you administer an instance of SQL Server on a database server, or if you plan to develop SQL Server applications.
The client components option installs the following SQL Server features: Command prompt tools, Reporting Services tools, connectivity components, programming models, management tools, development tools, and SQL Server Books Online. For more information, see How to: Install SQL Server 2008 (Setup).