SQL Server 2005 Edition upgrade.

There is no GUI option to upgrade SQL Server 2005 Edition upgrade. You have to run the following command from command window and make sure you change your directory to installation folder…
 
To upgrade Default instace:
setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
 
To upgrade Named instace:
setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=InstanceName UPGRADE=SQL_Engine SKUUPGRADE=1 /qb
 
Note: You have to apply all the service packs, Patches and hot fixes ect. after ugrade.
 

The following upgrade scenarios are supported in this release of SQL Server 2005:

Upgrade from

Supported Upgrade Paths

SQL Server 7.0 Enterprise Edition SP4

SQL Server 2005 Enterprise Edition

SQL Server 7.0 Developer Edition SP4

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 7.0 Standard Edition SP4

SQL Server 2005 Standard Edition

SQL Server 2005 Enterprise Edition

SQL Server 7.0 Desktop Edition SP4

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 7.0 Evaluation Edition SP4

Upgrades not supported

SQL Server Desktop Engine (MSDE) 7.0 SP4

SQL Server 2005 Express Edition

SQL Server 2000 Enterprise Edition SP3 or later1

SQL Server 2005 Enterprise Edition

SQL Server 2000 Developer Edition SP3 or later1

SQL Server 2005 Developer Edition

SQL Server 2000 Standard Edition SP3 or later1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2000 Workgroup Edition SP3 or later1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2000 Personal Edition SP3 or later1

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition

SQL Server 2005 Express Edition with Advanced Services

SQL Server 2000 Evaluation Edition SP3 or later1

SQL Server 2005 Evaluation Edition

SQL Server Desktop Engine (MSDE) 2000 SP3 or later1

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition

SQL Server 2005 Express Edition with Advanced Services

SQL Server 2000 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2000 IA64 (64-bit) Developer Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Developer Edition

SQL Server 2005 Developer Edition 1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Standard Edition1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Workgroup Edition1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Evaluation Edition1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition

SQL Server 2005 Express Edition 1

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 Express Edition with Advanced Services

SQL Server 2005 Express Edition with Advanced Services¹

SQL Server 2005 Enterprise Edition

SQL Server 2005 Developer Edition

SQL Server 2005 Standard Edition

SQL Server 2005 Workgroup Edition

SQL Server 2005 IA64 (64-bit) Developer Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Standard Edition

SQL Server 2005 X64 (64-bit) Developer Edition

SQL Server 2005 X64 (64-bit) Enterprise Edition

SQL Server 2005 X64 (64-bit) Standard Edition

SQL Server 2005 IA64 (64-bit) Standard Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Developer Edition

SQL Server 2005 X64 (64-bit) Standard Edition

SQL Server 2005 X64 (64-bit) Enterprise Edition

SQL Server 2005 X64 (64-bit) Developer Edition

SQL Server 2005 IA64 (64-bit) Evaluation Edition

SQL Server 2005 IA64 (64-bit) Enterprise Edition

SQL Server 2005 IA64 (64-bit) Developer Edition

SQL Server 2005 IA64 (64-bit) Standard Edition

SQL Server 2005 X64 (64-bit) Evaluation Edition

SQL Server 2005 X64 (64-bit) Enterprise Edition

SQL Server 2005 X64 (64-bit) Developer Edition

SQL Server 2005 X64 (64-bit) Standard Edition

1This SQL Server edition can be upgraded to SQL Server 2005 on the 32-bit subsystem (WOW64) of a 64-bit server.

 
Advertisements
This entry was posted in SQL Server 2005 Upgrade. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s