On the heels of SQL Server 2008 being released to manufacturing last week, SQL Server 2008 Express was made available for download today. As with SQL Server 2005 Express, SQL Server 2008 Express will be released in stages. SQL Server 2008 with Advanced Services and the new SQL Server 2008 Express with Tools edition will be made available in coming weeks.

SQL Server 2008 Express with Tools includes the core database engine and SQL Server Management Studio Basic. This is the ideal edition for people that want the essential tools for developing relational database applications. Advanced features such as Integrated Full Text Search, Reporting Services and BIDS will be available in SQL Server 2008 Express Advanced.

Resource Links

Prerequisites

Overview

  • SQL Server 2008 Express  (for Advanced users)
    • SQL Server database engine - Create, store, update and retrieve your data
    • Available: Now
  • SQL Server 2008 Express with Tools (Recommended - New)
    • SQL Server database engine - Create, store, update and retrieve your data
    • SQL Server Management Studio Basic - Visual database management tool for creating, editing and managing databases
    • Available: End of August 2008
  • SQL Server 2008 Express with Advanced Services (for Advanced users)
    • SQL Server database engine - Create, store, update and retrieve your data
    • SQL Server Management Studio Basic - Visual database management tool for creating, editing and managing databases
    • Full-text Search - Powerful, high-speed engine for searching text-intensive data
    • Reporting Services - Integrated report creation and design environment to create reports
    • Available: End of August 2008

Feature

SQL Server 2008 Express

SQL Server 2008 Express with Tools

SQL Server 2008
Express with
Advanced Services

Tools & Management

     

PowerShell Integration

image

(Separate installation)*

image

image

Policy Based Management

image

(Manual only)**

image

(Manual only)*

image

(Manual only)**

Import/Export Wizard

image

image

image

Management Studio Basic

image

image

SQL Engine

     

Integrated Full Text Search

image

Merge & Upsert

image

image

image

New Data type support

     

Filestream support

image

image

image

New Date & Time data types

image

image

image

Geodetic data types

image

image

image

Advanced Spatial Libraries

image

image

image

Support for Spatial Standards

image

image

image

Replication

     

Change Tracking

image

image

image

Synchronization Services

image 

(Separate installation)***

image

image

Reporting Services

     

Increase RS Memory Limit

   

image

RS Word/Rich Text Export

   

image 

IIS Agnostic Report Deployment

   

image 

Enhanced Gauges & Charting

   

image

Business Intelligence Developer's Studio

   

image 

Size & Architectures

     
Approximate download sizes 55MB 110MB 570MB
32-bit installer
(x86 platforms only)

image 

image 

image 

64-bit installer
(x64 platforms only)

image 

image

image

Prerequisites

     
.NET Framework 3.5 SP1

image

image

image 

Windows Installer 4.5

image

image

image

Windows PowerShell 1.0  

image

image 

Notes:

* The SqlPS command line tool can be enabled in SQL Server 2008 Express by installing Windows PowerShell 1.0 before installing SQL Server 2008 Express.

** Policies can be created in SQL Server 2008 Express and run manually. There is no support for automated policy based management.

*** Synchronization Services support in SQL Server 2008 Express requires that you install the component separately from the SQL Server 2008 Feature Pack.