Feature

SQL Server 2008 Express

SQL Server 2008 Express with Tools

SQL Server 2008 Express with Advanced Services

Management

PowerShell Integration

Y (Separate installation)*

Y

Y

Policy Based Management

Y (manual only)**

Y (manual only)*

Y (manual only)**

Management Studio Basic

N

Y

Y

SQL Engine

Integrated Full Text Search

N

N

Y

Merge & Upsert

Y

Y

Y

New Data type support

Filestream support

Y

Y

Y

New Date & Time data types

Y

Y

Y

Geodetic data types

Y

Y

Y

Advanced Spatial Libraries

Y

Y

Y

Support for Spatial Standards

Y

Y

Y

New Tools

Import/Export Wizard

Y

Y

Y

Replication

Change Tracking

Y

Y

Y

Synchronization Services

Y (Separate installation)***

Y

Y

Reporting Services

Increase RS Memory Limit

N

N

Y

RS Word/Rich Text Export

N

N

Y

IIS Agnostic Report Deployment

N

N

Y

Enhanced Gauges & Charting

N

N

Y

Business Intelligence Developer's Studio

N

N

Y