Find discontinued features

Alex1

Hello,

I want to upgrade an SQL Server 2008 R2 to SQL Server 2016. I would like to find the queries running in production (on SQL Server 2008 R2) that use discontinued features of SQL Server 2016. Is there a way to find these discontinued features?

Russell D

I'd take a look at https://docs.microsoft.com/en-us/sql/database-engine/deprecated-database-engine-features-in-sql-server-2016, whilst there's nothing query specific it does contain all of the sprocs, functions, options etc that are being deprecated/removed, so you might be able to narrow down what you need from it.

Alex1

I need a tool, that analyzes a production trace file and finds the discontinued features of SQL Server 2016.

Russell D

Oh right you want a tool to do it for you. Well it's built into SQL Server. Use SQL Server Profiler to issue Deprecated Announcements, and then profile your code. You'll get Deprecated Announcements showing up in the SQL Logs. It'll require some (minimal) legwork though.

Oh and the SQL Profiler has ironically been deprecated, but its in SQL Server 2016 (its final version).

amalia_tracy

there is no tool to find discontinued features of SQL server 2008 R2, you have to manually do it, use SQL profiler to issue deprecated announcements.