You can upgrade from SQL Server 2000 or SQL Server 2005 to SQL Server 2008 using either an in-place or side-by-side upgrade.
Tip
 |
Prior to upgrading, run the Upgrade Advisor, available at http://www.microsoft.com/sql, against your SQL Server 2000 and 2005 instances and code base to determine any incompatibilities.
|
In-Place Upgrade
An in-place upgrade allows you to install SQL Server 2008 over the top of an existing SQL Server 2000 or 2005 instance. SQL Server will perform the following actions during an in-place upgrade:
Install SQL Server 2008 binaries
Upgrade the SQL Server 2000 or 2005 databases
Remove SQL Server 2000 or 2005 binaries, services, and registry entries
Start the SQL Server 2008 instance
At the completion of an in-place upgrade, the SQL Server 2000 or 2005 instance will be replaced by the SQL Server 2008 instance. Your databases, security settings, and configuration options will migrate to the new SQL Server 2008 instance. The previous SQL Server 2000 or 2005 instance will no longer exist on the machine.
Side-by-Side Upgrade
A side-by-side upgrade allows you to install a SQL Server 2008 instance without affecting the existing SQL Server 2000 or 2005 instance. Once installed, you will need to move all of your SQL Server 2000 or 2005 databases, objects, and settings over to the SQL Server 2008 instance.
Note
 |
Review the upgrade whitepapers on http://www.microsoft.com/sql, as well as the documentation that ships with the SQL Server Upgrade Advisor, for detailed information on upgrading from SQL Server 2000 and 2005.
|
While a side-by-side upgrade involves many more steps that have to be performed manually, it has the advantage of leaving SQL Server 2000 or 2005 instance intact. The side-by-side upgrade allows you to move databases to SQL Server 2008 in a staged manner.
Note
|
You cannot upgrade system databases using a side-by-side upgrade method. You will learn about system databases in article, “SQL Server 2008: Creating Databases.”
|
Upgrade Methods
When performing a side-by-side upgrade, you have three different methods to choose from:
When upgrading utilizing a backup and restore method, you will take a backup of your database from SQL Server 2000 or 2005 and restore it to SQL Server 2008.
Note
|
You will learn about backing up and restoring databases in article, “SQL Server 2008: Data Recovery.”
|
When upgrading utilizing the detach and attach method, you will detach the databases from SQL Server 2000 or 2005, copy the database files to a new location, and attach the database to the SQL Server 2008 instance.
Note
|
You will learn about detaching and attaching databases in article, “SQL Server 2008: Creating Databases.”
|
The Copy Objects Wizard, which is a task available within SQL Server Integration Services (SSIS), can be accessed in a variety of ways. The Copy Objects Wizard allows you to specify the database objects along with the migration settings that are used.
Tip
|
If you need to upgrade only a portion of a SQL Server 2000 or 2005 database, the Copy Objects Wizard provides a path to move only the set of objects that you want to upgrade. If you are upgrading the entire SQL Server 2000 or 2005 database, the Copy Objects Wizard provides the least efficient upgrade method.
|
