| title | Discontinued Management Tools Features in SQL Server 2014 | Microsoft Docs |
|---|---|
| ms.custom | |
| ms.date | 06/13/2017 |
| ms.prod | sql-server-2014 |
| ms.reviewer | |
| ms.technology | ssms |
| ms.topic | conceptual |
| ms.assetid | 6e58acd0-73c5-4161-9fbc-8ea531bc681c |
| author | stevestein |
| ms.author | sstein |
| manager | craigg |
This topic describes [!INCLUDEssNoVersion] Management Tools features that are no longer available in [!INCLUDEssNoVersion].
Features Removed in [!INCLUDEssCurrent]
None
Features Removed in [!INCLUDEssSQL11]
The SQL Server Compact Edition code editor has been removed from [!INCLUDEssManStudioFull]. 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.
The ActiveX subsystem for SQL Server Agent has been removed in this release. There is no replacement functionality.
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 have been removed in this release. Do not use this functionality in new or updated applications.
Some data-tier application (DAC) features present in [!INCLUDEssKilimanjaro] have been removed in [!INCLUDEssSQL11]. However, the Data-Tier Application Framework (DACfx version 3.0) released with [!INCLUDEssSQL11] is compatible with [!INCLUDEssVersion2005] through [!INCLUDEssSQL11] and [!INCLUDEssSDSfull]. DAC version 3.0 is not supported by earlier versions of [!INCLUDEssManStudio] including [!INCLUDEssManStudio] in [!INCLUDEssKilimanjaro]. 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 [!INCLUDEssNoVersion] Data Tools Database Projects.
DACfx 3.0 API and [!INCLUDEssNoVersion] tools do support reading DACPAC and BACPAC files created using earlier [!INCLUDEssNoVersion] tools and DACfx versions: extracting databases into DACPAC files from these versions, and deploying databases into supported versions of [!INCLUDEssNoVersion] through [!INCLUDEssManStudio] or [!INCLUDEssNoVersion] Data Tools.