O'Reilly logo

Professional Microsoft® SQL Server® 2008 Administration by Steven Wort, Ross LoForte, Wayne Snyder, Ketan Patel, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required