Discontinued Management Tools Features in SQL Server 2012

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

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 SQL Azure. Only SQL Server 2012 tools, Management Studio and SQL Server Data Tools, can interact with DAC version 3.0 packages - DAC version 3.0 is not supported by earlier versions of Management Studio including Management Studio in SQL Server 2008 R2. The specific changes between DAC version 1.1 and DAC version 3.0 are:

  • Microsoft.SqlServer.Management.Dac.dll which was installed in SQL Server 2008 R2 (DAC version 1.0) and SQL Server 2008 R2 Service Pack 1 is not installed in SQL Server 2012.

    • Microsoft.SqlServer.Management.Dac and Microsoft.SqlServer.Management.Dac.Bacpac namespaces are not present in SQL Server 2012 (DACfx version 3.0).

    • The IServer C# interface present in DACfx 1.1 API is not present in SQL Server 2012 (DACfx version 3.0).

    • DACfx version 3.0 API provided in SQL Server 2012 is not compatible with the DAC version 1.0 and 1.1 API that shipped with SQL Server 2008 R2.

      PowerShell scripts or .NET applications that use the DAC API that shipped prior to SQL Server 2012 will not work with SQL Server 2012 (or later) DAC API, DAC packages, or BACPAC files.

    • Microsoft recommends using the latest available version of the Data-Tier Application Framework (DACfx version 3.0 or higher).

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

See Also

Concepts

Backward Compatibility