Export (0) Print
Expand All

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.

Feature

Replacement

SQL-DMO

SQL Server Management Objects (SMO)

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.

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

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.

Community Additions

ADD
Show:
© 2014 Microsoft