Version and Edition Upgrades
The following upgrade scenarios are supported in this release of SQL Server.
Upgrade from |
Supported upgrade path |
|---|---|
SQL Server 2000 (32-Bit) MSDE SP41 |
SQL Server 2008 Express |
SQL Server 2000 (32-Bit) Standard SP41,4 |
SQL Server 2008 Standard SQL Server 2008 Enterprise |
SQL Server 2000 (32-Bit) Developer SP41,4 |
SQL Server 2008 Developer |
SQL Server 2000 (32-Bit) Enterprise SP41,4 |
SQL Server 2008 Enterprise |
SQL Server 2000 Enterprise Evaluation (32-bit, IA64)4,5 |
No upgrade support. |
SQL Server 2000 (64-Bit) IA64 Developer SP43,4,5 |
SQL Server 2008 (64-Bit) IA64 Developer |
SQL Server 2000 (64-Bit) IA64 Enterprise SP43,4,5 |
SQL Server 2008 (64-Bit) IA64 Enterprise |
SQL Server 2000 (32-Bit) Personal SP4 |
No upgrade support. |
SQL Server 2005 (32-Bit) Express1 |
SQL Server 2008 Express SQL Server 2008 Express Tools SQL Server 2008 Express Advanced SQL Server 2008 Workgroup |
SQL Server 2005 (32-Bit) Express1 Advanced1 |
SQL Server 2008 Express Advanced SQL Server 2008 Workgroup |
SQL Server 2005 (32-Bit) Workgroup1 |
SQL Server 2008 Workgroup SQL Server 2008 Standard SQL Server 2008 Enterprise |
SQL Server 2005 (32-Bit) Standard1 |
SQL Server 2008 Standard SQL Server 2008 Enterprise |
SQL Server 2005 (32-Bit) Developer1 |
SQL Server 2008 Developer |
SQL Server 2005 (32-Bit) Enterprise1 |
SQL Server 2008 Enterprise |
SQL Server 2005 Enterprise Evaluation (32-bit, IA64, X64) |
No upgrade support. |
SQL Server 2005 IA64 (64-bit) Developer |
SQL Server 2008 IA64 (64-bit) Developer |
SQL Server 2005 IA64 (64-bit) Standard |
SQL Server 2008 IA64 (64-bit) Enterprise |
SQL Server 2005 IA64 (64-bit) Enterprise |
SQL Server 2008 IA64 (64-bit) Enterprise |
SQL Server 2005 X64 (64-bit) Developer |
SQL Server 2008 X64 (64-bit) Developer |
SQL Server 2005 X64 (64-bit) Standard |
SQL Server 2008 X64 (64-bit) Standard SQL Server 2008 X64 (64-bit) Enterprise |
SQL Server 2005 X64 (64-bit) Enterprise |
SQL Server 2008 X64 (64-bit) Enterprise |
SQL Server 2008 Express1 |
SQL Server 2008 Express SQL Server 2008 Express Tools SQL Server 2008 Express Advanced SQL Server 2008 Workgroup SQL Server 2008 Standard SQL Server 2008 Developer SQL Server 2008 Enterprise |
SQL Server 2008 Express Tools |
SQL Server 2008 Express Tools SQL Server 2008 Express Advanced SQL Server 2008 Workgroup SQL Server 2008 Standard SQL Server 2008 Developer SQL Server 2008 Enterprise |
SQL Server 2008 Express Advanced1 |
SQL Server 2008 Express Advanced SQL Server 2008 Workgroup SQL Server 2008 Standard SQL Server 2008 Developer SQL Server 2008 Enterprise |
SQL Server 2008 Express x64 (64-bit) |
SQL Server 2008 Express x64 (64-bit) SQL Server 2008 Express Tools x64 (64-bit) SQL Server 2008 Express Advanced x64 (64-bit) SQL Server 2008 Workgroup x64 (64-bit) SQL Server 2008 Standard x64 (64-bit) SQL Server 2008 Developer x64 (64-bit) SQL Server 2008 Enterprise x64 (64-bit) |
SQL Server 2008 Express Tools x64 (64-bit) |
SQL Server 2008 Express Tools x64 (64-bit) SQL Server 2008 Express Advanced x64 (64-bit) SQL Server 2008 Workgroup x64 (64-bit) SQL Server 2008 Standard x64 (64-bit) SQL Server 2008 Developer x64 (64-bit) SQL Server 2008 Enterprise x64 (64-bit) |
SQL Server 2008 Express Advanced x64 (64-bit) |
SQL Server 2008 Express Advanced x64 (64-bit) SQL Server 2008 Workgroup x64 (64-bit) SQL Server 2008 Standard x64 (64-bit) SQL Server 2008 Enterprise x64 (64-bit) |
SQL Server 2008 Workgroup1 |
SQL Server 2008 Workgroup SQL Server 2008 Standard SQL Server 2008 Enterprise |
SQL Server 2008 Web1 |
SQL Server 2008 Web |
SQL Server 2008 Standard1,2 |
SQL Server 2008 Standard SQL Server 2008 Enterprise |
SQL Server 2008 Developer1,2 |
SQL Server 2008 Workgroup SQL Server 2008 Standard SQL Server 2008 Developer SQL Server 2008 Enterprise |
SQL Server 2008 Enterprise1,2 |
SQL Server 2008 Enterprise |
SQL Server 2008 Enterprise Evaluation2 |
SQL Server 2008 Enterprise Evaluation SQL Server 2008 Web SQL Server 2008 Workgroup SQL Server 2008 Standard SQL Server 2008 Developer SQL Server 2008 Enterprise |
SQL Server 2008 IA64 (64-bit) Enterprise Evaluation2 |
SQL Server 2008 IA64 (64-bit) Enterprise SQL Server 2008 IA64 (64-bit) Developer SQL Server 2008 IA64 (64-bit) Enterprise Evaluation |
SQL Server 2008 x64 (64-bit) Enterprise Evaluation2 |
SQL Server 2008 Enterprise Evaluation SQL Server 2008 Web SQL Server 2008 Workgroup SQL Server 2008 x64 (64-bit) Standard SQL Server 2008 x64 (64-bit) Developer SQL Server 2008 x64 (64-bit) Enterprise |
SQL Server 2008 IA64 (64-bit) Developer2 |
SQL Server 2008 IA64 (64-bit) Developer SQL Server 2008 IA64 (64-bit) Enterprise |
SQL Server 2008 Developer x64 (64-bit)2 |
SQL Server 2008 Workgroup x64 (64-bit) SQL Server 2008 Standard x64 (64-bit) SQL Server 2008 Developer x64 (64-bit) SQL Server 2008 Enterprise x64 (64-bit) |
SQL Server 2008 x64 (64-bit) Standard2 |
SQL Server 2008 x64 (64-bit) Standard SQL Server 2008 x64 (64-bit) Enterprise |
SQL Server 2008 IA64 (64-bit) Enterprise2 |
SQL Server 2008 IA64 (64-bit) Enterprise |
SQL Server 2008 x64 (64-bit) Enterprise2 |
SQL Server 2008 x64 (64-bit) Enterprise |
1This SQL Server edition can be upgraded to SQL Server 2008 on the 32-bit subsystem (WOW64) of a 64-bit server.
2Changing the edition of a SQL Server 2008 failover cluster is limited. The following edition downgrade scenarios are not supported for SQL Server 2008 failover clusters:
SQL Server 2008 Enterprise to SQL Server 2008 Developer, Standard, or Enterprise Evaluation.
SQL Server 2008 Developer to SQL Server 2008 Standard or Enterprise Evaluation.
SQL Server 2008 Standard to SQL Server 2008 Enterprise Evaluation.
SQL Server 2008 Enterprise Evaluation to SQL Server 2008 Standard.
3Upgrade of SQL Server 2000 (64-Bit) IA64 failover clusters is not supported.
4Upgrade of SQL Server 2000 Analysis Services to SQL Server 2008 is not supported on failover clusters.
5Upgrade of SQL Server 2000 (64-Bit) will not install SQL Server 2008 Management Tools. To install Management Tools, you musr re-run Setup after the upgrade is complete.
Upgrade Notes
Cross-version instances of SQL Server 2008 are not supported. Version numbers of the Database Engine, Analysis Services, and Reporting Services components must be the same in an instance of SQL Server 2008.
Before upgrading SQL Server, enable Windows Authentication for SQL Server Agent and verify the default configuration: that the SQL Server Agent service account is a member of the SQL Server sysadmin group.
Before upgrading from one edition of SQL Server 2008 to another, verify that the functionality you are currently using is supported in the edition to which you are upgrading. For more information, see the section for your components in Features Supported by the Editions of SQL Server 2008.
Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit. However, you can upgrade a 32-bit instance of SQL Server to the WOW64: the 32-bit subsystem on a 64-bit server as noted in the table above. You can also back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to an instance of SQL Server (64-bit) if the databases are not published in replication. In this case, you must also re-create any logins and other user objects in master, msdb, and model system databases.
To upgrade to SQL Server 2008, you must be running a supported operating system. For more information, see Hardware and Software Requirements for Installing SQL Server 2008.
Upgrade will be blocked if there is a pending restart.
Upgrade will be blocked if the Windows Installer service is not running.
Upgrade will be blocked if performance counters are corrupt.
To upgrade an instance of SQL Server to a SQL Server failover cluster, the instance being upgraded must be a failover cluster. To upgrade a stand-alone instance of SQL Server to a SQL Server failover cluster, install a new SQL Server failover cluster and then migrate user databases from the stand-alone instance by using the Copy Database Wizard. For more information about upgrade, see How to: Upgrade a SQL Server Failover Cluster Instance (Setup). For more information about database migration, see Using the Copy Database Wizard.
Adding Components to an Instance of SQL Server
You cannot add components to an existing installation of SQL Server at the time you upgrade to SQL Server 2008.After you upgrade an instance of SQL Server to SQL Server 2008, you can add features by using the SQL Server 2008 Installation Wizard: Setup.exe.
Cross-Language Support
The English-language version of SQL Server is supported on all localized versions of supported operating systems.
Localized versions of SQL Server are supported on localized operating systems that are the same language as the localized SQL Server version.
Localized versions of SQL Server can be upgraded to localized versions of SQL Server 2008 of the same language.
Localized versions of SQL Server cannot be upgraded to the English-language version of SQL Server 2008.
Localized versions of SQL Server cannot be upgraded to localized SQL Server 2008 versions of a different localized language.
Localized versions of SQL Server are also supported on English-language versions of supported operating systems by using the Windows Multilingual User Interface Pack (MUI) settings. However, you must verify certain operating system settings before you install a localized version of SQL Server on a server that is running an English-language operating system with a non-English MUI setting. You must verify that the following operating system settings match the language of SQL Server to be installed:
The operating system user interface setting
The operating system user locale setting
The system locale setting
If these operating system settings do not match the language of the localized SQL Server, you must correctly set these operating system settings before you install SQL Server 2008.