Sql Server Procedures migration (2005 to 2012) RRS feed

  • Question

  • Hi All,

    We are migrating sql server Stored Procedures from 2005 to 2012.

    We are facing some conflicts(Keyword changes) while migrating into 2012. We are executing each and every stored procedure and

    finding some keyword changes.We have nearly 2000 stored procedures. It is a time consuming process.

    What are the best way to find out the changes in 2012

    Does anyone have script(Sql server) to find out/what are the changes need to be change in 2012.

    Thanks in advance...

    Monday, July 27, 2015 6:28 AM


  • I would suggest you to first run SQL server 2012 upgrade advisor it would point to ALL BREAKING CHANGES. You can learn more about breaking changes in SQl Server 2012

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My Technet Wiki Article


    • Proposed as answer by Ashwin Menon Monday, July 27, 2015 9:07 AM
    • Marked as answer by Charlie Liao Wednesday, August 5, 2015 1:58 AM
    Monday, July 27, 2015 6:58 AM

All replies