Chapter 8. Upgrading to SQL Server 2005


SQL Server 2005 offers an array of new functionality that makes upgrading an irresistible proposition. And whether you’re a gung-ho developer or the most conservative of administrators, there’s an upgrade path to suit your comfort level. This chapter provides the best practices you need to upgrade without a hitch.

What’s New in Upgrading SQL Server

For the simplest setups, most of your existing SQL Server 7 or 2000 components can be automatically upgraded in-place without negatively affecting existing applications. For more complex environments, you can install SQL Server ...

Get Microsoft® SQL Server 2005 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.