Working with Multiple Versions and Instances of SQL Server
SQL Server supports multiple instances of the Database Engine, Analysis Services, and Reporting Services on the same computer. You can also upgrade earlier versions of SQL Server, or install SQL Server on a computer where earlier SQL Server versions are already installed. For supported upgrade scenarios, see Version and Edition Upgrades.
You can install SQL Server on a computer that is already running instances of an earlier SQL Server version. If a default instance already exists on the computer, SQL Server must be installed as a named instance. Be aware that there are special considerations while using SQL Server 2008 R2 and SQL Server 2008 side-by-side. For more information, see Considerations for Side-by-Side Instances of SQL Server 2008 R2 and SQL Server 2008. The considerations may also apply in situations where there was a previously existing SQL Server 2008 R2 installation on the machine.
The following table shows side-by-side support for SQL Server 2008 R2:
|
Existing instance of SQL Server 2008 R2 |
Side-by-side support |
|---|---|
|
SQL Server 2008 R2 (32-bit) |
SQL Server 2000 (32-bit) SQL Server 2000 (64-bit) x64 SQL Server 2005 (32-bit) SQL Server 2005 (64-bit) x64 SQL Server 2008 (32-bit) SQL Server 2008 (64-bit) x64 SQL Server 2008 R2 (32-bit) SQL Server 2008 R2 (64-bit) x64 |
|
SQL Server 2008 R2 (64-bit) IA64 |
SQL Server 2005 (64-bit) IA64 SQL Server 2008 (64-bit) IA64 SQL Server 2008 R2 (64-bit) IA64 |
|
SQL Server 2008 R2 (64-bit) x64 |
SQL Server 2000 (32-bit) SQL Server 2000 (64-bit) x64 SQL Server 2005 (32-bit) SQL Server 2005 (64-bit) x64 SQL Server 2008 (32-bit) SQL Server 2008 (64-bit) x64 SQL Server 2008 R2 (32-bit) SQL Server 2008 R2 (64-bit) x64 |