Upgrading from SQL 2008 to SQL 2016
NHS_SQL_DEVELOPER
Posts: 2 New member
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!
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!
Answers
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.