Breaking Changes to Management Tools Features in SQL Server 2014

Article
11/27/2018

This topic describes breaking changes to management tools features. These changes might break applications, scripts, or functionalities that are based on earlier versions of SQL Server. You might encounter these issues when you upgrade. For more information, see Use Upgrade Advisor to Prepare for Upgrades.

Breaking Changes in SQL Server 2014

Information to come later.

Breaking Changes in SQL Server 2012

You cannot use SQL Server 2012 Management Tools to create a utility control point on a SQL Server 2008 R2 instance of SQL Server

To create a utility control point on an instance of SQL Server 2008 R2, use SQL Server 2008 R2 Management Tools.

SMO has been reversioned in SQL Server 2012

Code developed with SMO from SQL Server 2008 R2 or earlier versions might not build against SQL Server 2012 without minor modifications. For more information, see Backward Compatibility in SMO.

Breaking Changes in SQL Server 2005

We accumulate and retain documentation for very old versions of Microsoft SQL Server in a set of archive webpages. The archived webpages are not processed by search engines, such as Bing.com and Google.com. But you can see these archives at our Docs previous-versions/ address:

https://docs.microsoft.com/previous-versions/sql/

These archives include the documentation for at least the following older versions:

SQL Server 2014
SQL Server 2012
SQL Server 2008 R2
SQL Server 2008
SQL Server 2005

SQL Server 2014 documentation has been archived, and is no longer processed by search engines. The 2014 articles now declare themselves with NOINDEX and NOFOLLOW.

The latest version of SQL Server, along with other recent versions, is documented here.