Find discontinued features before migrating to SQL Server 2016
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 the queries that use these discontinued features? The Database Migration Assistant only looks at the database schema (tables, stored procedures, triggers), it does not capture queries that are issued from the application.
In addition to DMA, it is always the best thing while doing any upgrade to trace (Profiler/Externded events etc.) all the workload in the existing server and replay it on the new server. You can filter the trace to the specified application, but I would not recommend that. I know this could be difficult but the benefits like finding actual errors/warnings, performance comparison etc., there will more gains than pains. Nothing is better than if you can present the clear picture the Management/Stake holders through a real time run. But this does not mean that it would be bullet proof, there could be some unseen situations like a Monthly/Quarterly process or a sleeping application is started. But you would have covered all the major scenarios in advance. Having said that, the good news is that the list of discontinued features since 2012 is not that long as compared to the deprecated features :)