Once you have finished the planning phase and all preparations it's time to perform the upgrade/migration of your SQL Server environment. For the scenario used in this chapter, we'll upgrade an existing SQL Server 2016 to SQL Server 2017. One thing you also need to carefully consider is the edition upgrade path, which you need to follow.
Performing the upgrade
We will be upgrading Enterprise Edition and the Edition will stay the same after the upgrade. You can, however, upgrade between editions. You can find the whole edition and version upgrade matrix on Microsoft's website at https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades where you can see what versions and editions can be upgraded. ...
Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.