Installation Options (SQL Server Express)

Use the Installation Options page of the Microsoft SQL Server Installation Wizard to view maintenance and upgrade options for existing SQL Server Express instances and components. This page appears when components selected for the current installation are already part of an existing installation with the same instance name.

Options

Maintenance and upgrade options are described in the following sections.

Maintenance

SQL Server Express instance maintenance and feature maintenance is provided through Add or Remove Programs in Control Panel. Select the instance of SQL Server to which you want to add or remove features. For more information, see How to: Change Components in an Existing Instance of SQL Server 2005 (Setup).

Upgrade

Supported upgrade paths are as follows:

Current SQL Server Instances Upgrade to SQL Server Express (32-Bit) Upgrade to SQL Server Express with Advanced Services (32-Bit)

SQL Server Desktop Engine (MSDE) 7.0 (SP4)

Yes

Yes

SQL Server 7.0 Desktop Edition SP4

No

No

SQL Server 7.0 Standard Edition SP4

No

No

SQL Server Developer Edition SP4

No

No

SQL Server Enterprise Edition SP4

No

No

SQL Server 7.0 Evaluation Edition SP4

Upgrades not supported

Upgrades not supported

SQL Server Desktop Engine (MSDE) 2000 SP3 or later

Yes

Yes

SQL Server 2000 Personal Edition SP3or later

Yes

Yes

SQL Server 2000 Workgroup Edition SP3 or later

No

No

SQL Server 2000 Standard Edition SP3or later

No

No

SQL Server 2000 Developer Edition SP3 or later

No

No

SQL Server 2000 Enterprise Edition SP3 or later

No

No

SQL Server 2000 Evaluation Edition or later

No

No

SQL Server 2005 Express Edition

No

Yes

SQL Server 2005 Enterprise Edition

No

No

SQL Server 2005 Workgroup Edition

No

No

SQL Server 2005 Standard Edition

No

No

SQL Server 2005 Developer Edition

No

No

SQL Server 2005 Evaluation Edition

No

No