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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Robert, forgot to mention that the SSIS packages are written in visual studio 2008.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Robert, well done
JohnE
JohnE
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
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
ASKER
Thank you Robert, well done !
ASKER
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