Skip to main content

Event Review: Upgrading to SQL Server 2005 (Session ITPROSQL-10)

Welcome to the material supporting page for this session. The materials on this page have been selected as the best matches to the content covered in the live event session.

Session Outline

The goal of this session is to provide you with the knowledge you need to upgrade an existing SQL 7.0 or SQL 2000 server to SQL Server 2005. We will look at the Microsoft SQL Server 2005 Upgrade Advisor which you can use to prepare for upgrades to SQL Server 2005. Your existing SQL Server instance can be upgraded to SQL Server 2005 using either a migration process, which involves installing SQL Server 2005 on a new server and then migrating data, or through an in-place upgrade that upgrades your existing installation. We will explore the different techniques and benefits of both.

Session Agenda

  • Pre-upgrade considerations
  • Using the Upgrade Advisor
  • Migration vs. upgrade concepts
  • Upgrading a SQL 2000 instance

Related Links

Use the following resources to learn more about topics covered in this briefing.

Microsoft Press Books

Third-Party Books

  • SQL Server 2005 Distilled

    Summary: SQL Server 2005 Distilled offers realistic insight into every significant aspect of SQL Server 2005: its new features, architecture, administrative tools, security model, data management capabilities, development environment, and much more.
    Sample Chapter

  • Microsoft SQL Server 2005 A Beginner's Guide

    Summary: This bestselling beginner's guide gets users up and running on SQL Server 2005. The book covers database concepts, and discusses key topics for new users including the SQL Server Workbench, T-SQL, automated administration tasks, security, and analysis.
    Sample Chapter

  • Microsoft SQL Server 2005 The Complete Reference

    Summary: Filled with practical solutions and real-world examples, this resource includes full details on: Enterprise data management capabilities, including security and clustering Powerful developer tools -- T-SQL, .NET CLR, XML, ADO.NET 2.0 Business Intelligence features, such as Integration Services, data warehousing, and reports.

  • Microsoft SQL Server 2005 Reporting Services 2005

    Summary: With coverage of everything from installation to administration, the book demonstrates how to use this powerful server-based reporting solution to improve business decision-making and facilitate company-wide -- even worldwide -- communication.
    Sample Chapter