Wednesday, June 11, 2008

Deprecated and Discontinued Features in SQL Server 2008

Everybody is waiting for the new features coming with Microsoft SQL Server 2008, but there are some deprecated and discontinued features that we should be aware of. Deprecated features are features found in previous versions of SQL Server that are no longer recommended to be used in newer products, and they are going to be removed from future versions of the server. Discontinued features are those features no longer available in SQL Server 2008. It is important to notice what those features are before migrating to SQL Server 2008.

The deprecated and discontinued features are found in a backward compatibility online document on MSDN. There are several major areas with many compatibility issues:

  1. Database Engine
  2. Analysis Services
  3. Integration Services
  4. Reporting Services
  5. Replication
  6. Full-text Search
Beside those deprecated and discontinued features, there are numerous breaking and behavioral changes in the product in the respective areas. A breaking change might break an application or a script built on a previous version of SQL Server. A behavioral change affects the way features work in SQL Server. It is recommended to consult the documentation before upgrading to SQL Server 2008, or using the Upgrade Advisor, an application which analyses the current installation of SQL Server and generates a report with various issues that need to be fixed either before or after the upgrade.

No comments: