On my SQL Server 2019 machine, I have a database that is running on the lowest supported compatibility level (I believe that's equivalent to SQL Server 2008). I want to switch it to the very highest. Do I need to check for deprecated features first?
This feels like it should be a duplicate, but I've not managed to find anything mentioning both topics.
Best Answer
Not exactly, deprecated features are planned to stop working but discontinued features actually do not work in the later version.
Data migration assistant will be very helpful & also the comment by Martin Smith:
https://learn.microsoft.com/en-us/sql/database-engine/discontinued-database-engine-functionality-in-sql-server?view=sql-server-ver16