How can we help you today? How can we help you today?

Upgrading from SQL 2008 to SQL 2016

Hi all,

I have an interview next week where I have to give a presentation on upgrading from SQL Server 2008 (R2) to SQL Server 2016. 

Obviously I have done my own research, however I'm really interested in your experience in upgrading to SQL 2016, the benefits, positives and negatives, is it worth it? What impact did it have on you?

I have posted on StackOverflow with no success so hoping you kind people could provide me with some personal experiences for me to use in my presentation.

Any reply is really appreciated!
NHS_SQL_DEVELOPER
0

Comments

2 comments

Sort by
  • ben_b
    Hello, this isn't specifically a red-gate question but there are some red-gate resources that can help you.

    this simple talk article looks decent

    https://www.red-gate.com/simple-talk/sql/database-administration/preparing-to-upgrade-your-sql-server/

    alternatively, you can search SQLServerCentral and/or post a question on the forum.

    The big thing with SQL Server 2016 SP1 is that you get most Enterprise Features included with Standard Edition.  I've migrated loads of databases and never really had any issues.  I'm sure there is some code analysis features in SQL Prompt that would alert you early. 

    Best advice I can give is don't wait around, give it a bash on a test environment and you will have a feel pretty quickly of how difficult the task will be.
    ben_b
    0
  • damvaydep
    Tks for help.
    damvaydep
    0

Add comment

Please sign in to leave a comment.