3.4. Backward Compatibility

This section covers major product changes, classified in one of three categories: unsupported, discontinued, or affecting the way SQL Server 2000 or 2005 behaves today. Although the Upgrade Advisor tool will highlight these conditions if they are relevant to your environment, you should read this section to familiarize yourself with these changes.

3.4.1. Unsupported and Discontinued Features

From time to time, to move a technology forward, trade-offs have to be made. From SQL 2000 to SQL 2005 to SQL Server 2008, the following features are no longer available:

  • English Query is no longer included; don't look for it on your installation media.

  • isql.exe and rbuildm.exe are no longer present. You will have to use sqlcmd.exe and setup.exe instead if you need to rebuild the master database or the registry.

  • The Northwind and Pubs databases have been replaced by the AdventureWorks2008 and AdventureWorksDW2008 databases. These new sample databases are intended to be more like real-life databases. If you want Northwind or Pubs sample databases, they are available at www.microsoft.com/downloads/details.aspx?familyid=06616212-0356-46a0-8da2-eebc53a68034.

  • The allow updates option of sp_configure is still present but not functional.

  • The metadata component of SQL Server 2000 DTS repository is deprecated as a feature. As part of the upgrade, the DTS packages will be migrated to the file system, and the specific tables will be present in msdb after upgrade.

  • SQL Server Surface ...

Get Professional Microsoft® SQL Server® 2008 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.