SQL Server Upgrade Advisor should check Database db_compat levels, not server version
We have a very common customer scenario where the customer decides to upgrade to a new version (in this case let’s say SQL Server 2012). They run upgrade advisor and note that there are a whole lot of problems. They think “Hey that’s way too much to deal with right now. I don’t have time”.
So they don’t deal with them. They upgrade the server to 2012 but leave their db_compat level at a lower level with the intention of dealing with the problems later.
2011-12-24