Upgrade MS SQL 2005 to MS SQL 2008

Follow these instructions to upgrade MS SQL 2005 to MS SQL 2008.

Upgrade from SQL 2005 Express to SQL 2008 Express

1. Download SQL 2008 Express from http://www.microsoft.com, or insert your SQL 2008 Express installation media. The SQL 2008 Express installer is located on the Vault installation media under <MEDIA>\x86\Support\Sql2008Express. It can be required to install Windows Installer 4.5 prior to SQL 2008 Express (KB942288).
2. Select the "Installation" option and begin the "Upgrade from SQL server 2000 or SQL Server 2005" Wizard.
   
3. Continue through the pre-installation process. Pre-request files and services are updated. Setup Support Rules are processed.
4. Select theAutodeskVault instance to upgrade, confirm instance settings.
   
5. Continue through Disk Space requirements, Upgrade rules, and Upgrade Process. Setup will complete and upgrade the AutodeskVault SQL instance to SQL 2008 Express.
6. Verify that SQL 2008 SP1 is installed. If it is not, download and install it from http://www.microsoft.com.

Upgrade from SQL 2005 Express to Full SQL 2008

1. Download SQL 2008 Express from http://www.microsoft.com, or insert your SQL 2008 Express installation media. The SQL 2008 Express installer is located on the Vault 2011 installation media under <MEDIA>\x86\Support\Sql2008Express. Please note that you may be required to install Windows Installer 4.5 prior to SQL 2008 Express (KB942288).
2. Select the "Installation" option and begin the "Upgrade from SQL server 2000 or SQL Server 2005" Wizard.
   
3. Continue through the pre-installation process. Pre-request files and services are updated. Setup Support Rules are processed.
4. Select theAutodeskVault instance to upgrade, confirm instance settings.
   
5. Continue through Disk Space requirements, Upgrade rules, and Upgrade Process. Setup completes and upgrades the AutodeskVault SQL instance to SQL 2008 Express.
6. Launch Setup.exe from the Full SQL 2008 installation media. Select the Maintenance option and being the Edition Upgrade wizard.
   
7. Verify version and or product key for Full SQL 2008 and proceed to the Select Instance window and choose the AutodeskVault instance.
   
8. Upgrade the Instance. Then, to install the SQL Management Studio, return to the "Installation" option, and be the "New SQL Server stand-alone installation, or add features to an existing installation" wizard.
9. Verify that SQL 2008 SP1 is installed. If it is not, download and install it from http://www.microsoft.com.

Upgrade from Full SQL 2005 to Full SQL 2008

1. Select the Installation option and begin the Upgrade from SQL server 2000 or SQL Server 2005 Wizard.
   
2. Continue through the pre-installation process. Pre-request files and services are updated. Setup Support Rules are processed.
3. Select the AutodeskVault instance to upgrade, confirm instance settings.
   
   Note: If you do not see the "Database Engine Services" listed as a component to be migrated, you are not following an accepted migration path. Acceptable migration paths are listed here http://msdn.microsoft.com/en-us/library/ms143393.aspx
4. Continue through Disk Space requirements, Upgrade rules, and Upgrade Process. Setup completes and upgrades the AutodeskVault SQL instance to Full SQL 2008.
5. Verify that SQL 2008 SP1 is installed. If it is not, download and install it from http://www.microsoft.com.