В этом 490-страничном документе описаны основные нюансы обновления существующих экземпляров SQL Server 2000 и SQL Server 2005 до SQL Server 2008.
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.
Скачать:
SQL Server 2008 Upgrade Technical Reference GuideТакже, доступен для загрузки:
SQL Server 2005 Upgrade Technical Reference Guide