Migrate SQL Server 2008 databases to 2016

Question

We are processing to migrate SQL Server databases from 2008 to 2016.

We are searching now for expired function or utilities used in SQL Server 2008 and not available in SQL Server 2016 before migration.

Do you have reference for that?

Answer 1

Here are few features removed in SQL Server 2016 (from MSDN):

• SQL Server 2016 is a 64-bit application. 32-bit installation is discontinued, though some elements run as 32-bit components

• Compatibility level 90 is discontinued. For more information, see ALTER DATABASE Compatibility Level (Transact-SQL).

Though you are migrating from SQL Server 2008 directly to SQL Server 2016, you need to consider the removed features of SQL Server 2012 & SQL Server 2014 as well

• Discontinued Database Engine Functionality in SQL Server 2014
• Discontinued Database Engine Functionality in SQL Server 2012