Deprecated Management Tools Features in SQL Server 2008 R2

This topic describes the deprecated Management Tools features that are still available in SQL Server 2008 R2. These features are scheduled to be removed in a future release of SQL Server. Deprecated features should not be used in new applications.

Features Not Supported in the Next Version of SQL Server

The following features will not be supported in the next version of SQL Server. Do not use these features in new development work, and modify applications that currently use these features as soon as possible.

Feature	Replacement
SQL-DMO	SQL Server Management Objects (SMO)
DAC Upgrade method: Microsoft.SqlServer.Management.DacStore.Upgrade().	The IncrementalUpgrade() method. For more information, see Upgrade a Data-tier Application.
SQL Server Compact Editor, and support for SQL Server Compact Edition in Object Explorer, Solution Explorer, and Template Explorer.	Use the Transact-SQL editors in Microsoft Visual Studio 2010 Service Pack 1, or Webmatrix.

Features Not Supported in a Future Version of SQL Server

The following features are supported in the next version of SQL Server, but will be removed in a later version. The specific version of SQL Server has not been determined.

Feature	Deprecation stage
SQL Server 2005 Registered Server API	Announcement
osql.exe	Warning
SQLMail	Warning
SMO class: Microsoft.SQLServer.Management.Smo.Information class	Announcement
SMO class: Microsoft.SQLServer.Management.Smo.Settings class	Announcement
SMO Class: Microsoft.SQLServer.Management.Smo.DatabaseOptions class	Announcement
SMO Class: Microsoft.SqlServer.Management.Smo.DatabaseDdlTrigger.NotForReplication property	Announcement
The Database Project System, including source-control integration, in SSMS	Announcement
Net send notifications (SQL Server Agent)	Announcement
Pager notifications (SQL Server Agent)	Announcement
The ActiveX subsystem (SQL Server Agent)	Announcement
The Transact-SQL Editor will not support the CTRL+E shortcut for running Transact-SQL scripts in the next version of SQL Server. Use the F5 or ALT+X shortcuts to run Transact-SQL scripts.	Warning

See Also

Other Resources

Backward Compatibility

Change History

Updated content
Added the DAC Upgrade() method to features discontinued in the next version.
Added Management Studio support for SQL Server Compact Edition to features discontinued in the next version.