Discontinued Management Tools Features in SQL Server 2014


This topic describes SQL Server Management Tools features that are no longer available in SQL Server.


SQL Server Compact Edition

The SQL Server Compact Edition code editor has been removed from SQL Server Management Studio. Support for SQL Server Compact Edition has also been removed from Object Explorer, Solution Explorer, and Template Explorer. Use the Transact-SQL editors in Microsoft Visual Studio 2010 Service Pack 1 or Webmatrix instead.

ActiveX Subsystem for SQL Server Agent

The ActiveX subsystem for SQL Server Agent has been removed in this release. There is no replacement functionality.

sp_addtask, sp_deletetask, sp_updatetask

Sp_addtask, sp_deletetask, and sp_updatetask have been removed in this release. Do not use this functionality in new or updated applications.

Net Send and Pager Notification

Net Send and Pager Notification have been removed in this release. Do not use this functionality in new or updated applications.

Data-tier Applications

Some data-tier application (DAC) features present in SQL Server 2008 R2 have been removed in SQL Server 2012. However, the Data-Tier Application Framework (DACfx version 3.0) released with SQL Server 2012 is compatible with SQL Server 2005 through SQL Server 2012 and Azure SQL Database. DAC version 3.0 is not supported by earlier versions of Management Studio including Management Studio in SQL Server 2008 R2. Visual Studio 2010 Database Projects do not support DAC 3.0 DACPAC packages or DAC Export (BACPAC) packages generated with DACfx version 3.0 or later.

Microsoft recommends using the latest available version SQL Server Data Tools Database Projects.

DACfx 3.0 API and SQL Server tools do support reading DACPAC and BACPAC files created using earlier SQL Server tools and DACfx versions: extracting databases into DACPAC files from these versions, and deploying databases into supported versions of SQL Server through Management Studio or SQL Server Data Tools.

Backward Compatibility