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