Estava procurando informações sobre migração das versões do SQL Server 2000 e 2005 para o 2008 e encontrei o seguinte documento disponível para download:

SQL Server 2008 Upgrade Technical Reference Guide

Os capítulos que você encontrará no guia são:

  • 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.

Achei interessante colocarem as referências para migração do MOSS 2007 e outras plataformas para o SQL Server 2008.

Se alguém já realizou esta migração e quiser comentar sobre as experiências adquiridas enviem comentários. Obrigado.