sql server 2014 upgrade advisor (upgrading from 2008r2)

  • we are in the process of upgrading from 2008r2 to 2014

    I have run the 2014 upgrade advisor, but something came up that was not noted in the advisor reports, specifically, FASTFIRSTROW being removed in sql 2012

    Is that because I would only see that if I were to run the 2012 upgrade advisor, in addition to the 2014 upgrade advisor? Or does neither version of the advisor pick up this kind of thing (i.e. would I have to rely solely on books online [Database Engine Backward Compatibility] to get this information)?

  • the upgrade advisor is letting you know you have a query that contains the hint FASTFIRSTROW, support for this has been dropped since sql server 2012. You'll need to rewrite the query before upgrading to sql server 2014

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • the advisor is NOT telling me about the FASTFIRSTROW, I got an error when I ran a query

    Is that because I would only see that if I were to run the 2012 upgrade advisor, in addition to the 2014 upgrade advisor? Or does neither version of the advisor pick up this kind of thing (i.e. would I have to rely solely on books online [Database Engine Backward Compatibility] to get this information)?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply