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.
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.
DAC Upgrade method: Microsoft.SqlServer.Management.DacStore.Upgrade().
The IncrementalUpgrade() method. For more information, see How to: 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.
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.
SQL Server 2005 Registered Server API
SMO class: Microsoft.SQLServer.Management.Smo.Information class
SMO class: Microsoft.SQLServer.Management.Smo.Settings class
SMO Class: Microsoft.SQLServer.Management.Smo.DatabaseOptions class
SMO Class: Microsoft.SqlServer.Management.Smo.DatabaseDdlTrigger.NotForReplication property
The Database Project System, including source-control integration, in SSMS
Net send notifications (SQL Server Agent)
Pager notifications (SQL Server Agent)
The ActiveX subsystem (SQL Server Agent)
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.