It's time for another release post, this time for RC0 of SQL Server 2008 Express and SQL Server 2008 Express with Advanced Services. Here is the information that everyone is waiting to hear about the SQL Express product line. (Note: If you're the impatient type you can skip to the end of this post to find the instructions for installing SQL Express.)
SQL Express 2008 has the same physical limitations that existed in SQL Express 2005:
Since people always ask - you can run SQL Express on machines that exceed these limits, SQL Express just ignores any addition CPUs or memory. SQL Express will take advantage of multiple cores on the single CPU by starting a scheduler for each core.
The same features available in SQL Express 2005 are still available in SQL Express 2008, if you need a refresher on those you can find them in the Feature Comparison chart in Books Online. This post only calls out the features in SQL Express that are new in 2008.
SQL Server 2008 Express
SQL Server 2008 Express with Advanced Services
Management Studio Basic
Y (Separate installation)*
Policy Based Management
Y (manual only)**
Merge & Upsert
New Data type support
New Date & Time data types
Geodetic data types
Advanced Spatial Libraries
Support for Spatial Standards
Y (Separate installation)***
Increase RS Memory Limit
RS Word/Rich Text Export
IIS Agnostic Report Deployment
Enhanced Gauges & Charting
* The SqlPS command line tool can be enabled in SQL Express by installing Windows PowerShell 1.0 before installing SQL Express.
** Policies can be created in SQL Express and run manually. There is no support for automated policy based management.
*** Synchronization Services support in SQL Express requires that you install the component separately. It is available from the SQL Server 2008 Feature Pack on the Microsoft Download Center.
SQL Express and SQL Express Advanced will be release in both 32-bit and 64-bit (x64 0nly). As in the past, SQL Express will available for download from the Microsoft Download Center and there will be multiple packages depending on your specific needs. The following types of packages will be released at RTM. (Not all of these will be available at RC0)
32-bit only installation package (x86 platforms only)
32-bit WoW installation package (x86 and x64 platforms)
64-bit native installation packages (x64 platforms only)
SQL Express Advanced
Installing SQL Express products
SQL Server 2008 introduces some new prerequisites to installation and as in the past, these prerequisites are not included in the SQL Express packages. You must install these prerequisites manually before installing either SQL Express product or the installation will fail.
SQL Express prerequisites
.NET Framework 2.0 SP2
Windows Installer 4.5
SQL Express Advanced prerequisites
.NET Framework 3.5 SP1
Windows PowerShell 1.0
Note 1: While the .NET Framework 2.0 SP2 is the technical prerequisite for the core SQL Express package, I've only found this available as part of the .NET Framework 3.5 SP1 (Beta at the time of RC0), which includes all services packs of the 2.0 and 3.0 release of the framework as well.
Note 2: You will need to reboot your computer after installing Windows Installer 4.5 on most platforms. SQL Server 2008 will fail to install if the reboot after Windows Installer 4.5 has not been completed.
Once all the pre-requisites have been installed you can install SQL Express or SQL Express Advanced by downloading the desired package and double clicking it to start the installation.
Download the .NET Framework 3.5 SP1 Beta from here.
Download Windows Installer 4.5 from here. (Pick the appropriate package for your environment.)
Download Windows PowerShell 1.0 from here. (Pick the appropriate package for your environment.)
Download SQL Server 2008 Express from here. (SQL Express links are at the bottom of the Instructions section.)
You can post Express specific question to the SQL Server Katmai Express forum.
You can post SQL Server 2008 general questions on the SQL Server Katmai forums.
You can file bugs and feature requests on SQL Server Connect site.