SQL and Win 2008 R2 -> SQL and Win 2016

morning team,

What is the best approach and practice to upgrade a production sql server 2008 r2 (on win server 2008 r2)  to sql and win 2016 servers?

JohnE
John EsraeloDatabase / SQL DeveloperAsked:
Who is Participating?
 
RobertConnect With a Mentor System AdminCommented:
Simple high level the following is the approach I would take.
Build your new server
install SQL
Backup the database\databases on your existing server.
Restore DBs to the new server.

If you need to do an in place upgrade you would need to go to server 2012 in between as there is no supported upgrade path directly from 2008 to 2016.
0
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
That's very true, it is a catch 22, you cannot have 2008 sql on 2016 and you cannot have 2016 sql on 2008 r2 windows.
Here is 2 possible related questions:  1> can the sql server name be aliased in surface configuration so we don't have to rename all the "callers" and 2> do we have to recompile all the 32 bit in-house applications to 64 bit including the SSIS packages?

thx Robert

JohnE
0
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
Robert, forgot to mention that the SSIS packages are written in visual studio 2008.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
RobertConnect With a Mentor System AdminCommented:
As long as your instance names are the same (default or otherwise) then all you would need to do is create a DNS alias to redirect current clients to the new server or you can go through the process and rename it to match current server name after you shutdown the current one. (if you do rename don't forget to correct the SPN's)

As for SSIS I don't have a lot of knowledge on that (or know how your in house apps utilize the integration service) however generally speaking you normally would not need to.
0
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
Thank you Robert, well done


JohnE
0
 
Eugene ZCommented:
Before running SQL Server Setup to upgrade to SQL Server 2016, review the following topics about the upgrade process and the release notes
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server

and start with Prepare for upgrade by running Data Migration Assistant
https://docs.microsoft.com/en-us/sql/database-engine/install-windows/prepare-for-upgrade-by-running-data-migration-assistant
--

it makes sense to start all this from non prod server
0
 
John EsraeloDatabase / SQL DeveloperAuthor Commented:
Thank you Robert, well done !
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.