locked
SQL server 2012 to SQL 2016 RRS feed

  • Question

  • Hello All,

    Currently, we are using below version detail of SQL server in the production environment and would like to upgrade to SQL 2016  

    Microsoft SQL Server 2012 (SP3) (KB3072779) - 11.0.6020.0 (Intel X86) 
    Oct 20 2015 15:41:49 
    Copyright (c) Microsoft Corporation
    Standard Edition on Windows NT 6.1 <X64> (Build 7601: ) (WOW64) (Hypervisor)

    Could someone highlight any benefits and known issues for this upgrade, please? Many Thanks. 


    Monday, July 17, 2017 4:55 AM

Answers

  • Hi Anupam Soni02,

     

    There are many benefits for upgrading to SQL Server 2016, some useful features added including one programming surface across all editions, Always Encrypted, Polybase, Basic R integration, JSON Support. Besides, better compatibility with Azure and better performance counts. What's more, stretch database for hybrid cloud.

     

    To avoid some issues may be met when upgrading, please use Data Migration Assistant before upgrading, it will advise you on what actions you should take when upgrading to SQL 2016.

     

    In a word, it is suggested to upgrade SQL Server 2012 to 2016, by the way, SQL Server 2017 will be released not a long time, it will provides more features and can support Linux.

     

    Best Regards,

    Teige

     


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Teige Gao Tuesday, August 1, 2017 7:15 AM
    • Marked as answer by Anupam Soni02 Thursday, August 10, 2017 12:11 PM
    Monday, July 17, 2017 6:23 AM
  • Hello,

    Additional, with SP 1 for SQL Server 2016 you get also in-memory Features in Standard Edition (as yours), what was before only available in Enterprise.

    In-Memory OLTP in Standard and Express editions, with SQL Server 2016 SP1


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Teige Gao Tuesday, August 1, 2017 7:15 AM
    • Marked as answer by Anupam Soni02 Thursday, August 10, 2017 12:11 PM
    Monday, July 17, 2017 7:03 AM

All replies

  • Hi Anupam Soni02,

     

    There are many benefits for upgrading to SQL Server 2016, some useful features added including one programming surface across all editions, Always Encrypted, Polybase, Basic R integration, JSON Support. Besides, better compatibility with Azure and better performance counts. What's more, stretch database for hybrid cloud.

     

    To avoid some issues may be met when upgrading, please use Data Migration Assistant before upgrading, it will advise you on what actions you should take when upgrading to SQL 2016.

     

    In a word, it is suggested to upgrade SQL Server 2012 to 2016, by the way, SQL Server 2017 will be released not a long time, it will provides more features and can support Linux.

     

    Best Regards,

    Teige

     


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    • Proposed as answer by Teige Gao Tuesday, August 1, 2017 7:15 AM
    • Marked as answer by Anupam Soni02 Thursday, August 10, 2017 12:11 PM
    Monday, July 17, 2017 6:23 AM
  • Hello,

    Additional, with SP 1 for SQL Server 2016 you get also in-memory Features in Standard Edition (as yours), what was before only available in Enterprise.

    In-Memory OLTP in Standard and Express editions, with SQL Server 2016 SP1


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Proposed as answer by Teige Gao Tuesday, August 1, 2017 7:15 AM
    • Marked as answer by Anupam Soni02 Thursday, August 10, 2017 12:11 PM
    Monday, July 17, 2017 7:03 AM