SQL Server 2008 Upgrade Guide – Updated

Fresh off the presses. Microsoft just released the Microsoft SQL Server 2008 Upgrade Guide. Everythingyou want to know for migrating from SQL Server 2000 & SQL Server 2005 to Microsoft SQL Server 2008.

SQL Server 2008 Upgrade Technical Reference Guide

Brief Description
This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online
 
 

Overview

A successful upgrade to SQL Server 2008 should be smooth and trouble-free. To achieve that smooth transition, you must devote plan sufficiently for the upgrade, and match the complexity of your database application. Otherwise, you risk costly and stressful errors and upgrade problems. Like all IT projects, planning for every contingency and then testing your plan gives you confidence that you will succeed. But if you ignore the planning process, you increase the chances of running into difficulties that can derail and delay your upgrade. This document covers the essential phases and steps involved in upgrading existing SQL Server 2000 and 2005 instances to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks.

  • Chapter 1 gives an overview of the technical issues and decisions that are involved in an upgrade to SQL Server 2008, as well as recommendations for planning and deploying an upgrade.
  • Chapter 2 addresses issues related to upgrading to SQL Server 2008 Management Tools.
  • Chapters 3 through 8 focus on upgrade issues for SQL Server relational databases.
  • Chapter 9 addresses upgrading to SQL Server 2008 Express.
  • Chapters 10 through 14 focus on upgrading to SQL Server 2008 Business Intelligence components: Analysis Services, Data Mining, Integration Services, and Reporting Services.
  • Chapter 15 addresses the implications of upgrading to SQL Server 2008 for other Microsoft applications and platforms.
  • Appendix 1 contains a table of allowed SQL Server 2008 version and edition upgrade paths.
  • Appendix 2 contains an upgrade planning checklist.

 
Here are some other resources to help with the upgrade….
 

General Upgrade Issues

Use these sources to support upgrade planning and deployment and upgrading the SQL Server Management Tools.

Upgrade Planning and Deployment (Chapter 1)

Management Tools (Chapter 2)

Relational Engine Components

For upgrading relational engine components, use the following references:

Relational Databases (Chapter 3)

High Availability (Chapter 4)

Failover Clustering (4.1)

Log Shipping (4.2)

Information will be added here as appropriate.

Database Mirroring (4.3)

Information will be added here as appropriate.

Replication (4.4)

Information will be added here as appropriate.

Other References (4.5)

Database Security (Chapter 5)

Full-Text Search (Chapter 6)

Service Broker (Chapter 7)

Information will be added here as appropriate.

Transact-SQL Queries (Chapter 8)

Information will be added here as appropriate.

Notification Services (Chapter 9)

SQL Express/MSDE (Chapter 10)

Business Intelligence Components

You can use the following links to support upgrading business intelligence (BI) components to SQL Server 2008:

Analysis Services (Chapter 11)

Data Mining (Chapter 12)

Integration Services (Chapter 13)

Other References (13.1)

Reporting Services (Chapter 14)

Other Microsoft Applications and Platforms

SQL Server is used in other Microsoft applications and supported by other Microsoft platforms. You can use the following links to support upgrading to these other applications and platforms.

Upgrade Considerations for Other Microsoft Applications and Platforms (Chapter 15)

Microsoft Small Business Server (15.1)

Microsoft Office Communications Server (15.2)

Microsoft Office SharePoint Server (MOSS) 2007 (15.3)

Microsoft System Center 2007 (15.4)

Microsoft Dynamics (15.5)

Information will be added here as appropriate.

 

To go to the original source for all these reources. It will have the most up to date information click here……

Resources for Upgrading to SQL Server 2008

 

 

Posted Michael Corey,

Founder & CEO, Ntirety

www.ntirety.com

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.