Upgrade SQL Server 2016 to 2019

%3CLINGO-SUB%20id%3D%22lingo-sub-2040787%22%20slang%3D%22en-US%22%3EUpgrade%20SQL%20Server%202016%20to%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2040787%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20any%20known%20issues%20in%20upgrading%20from%20SQL%20Server%202016%20to%202019%3F%20Can%20it%20be%20done%20by%20a%20SQL%20novice%20or%20do%20you%20need%20to%20have%20more%20knowledge%20to%20perform%20the%20upgrade%3F%20We%20currently%20are%20using%26nbsp%3BMicrosoft%20SQL%20Server%202016%20(SP2-CU12)%20(KB4536648)%20-%2013.0.5698.0%20(X64)%20Feb%2015%202020%2001%3A47%3A30%20Copyright%20(c)%20Microsoft%20Corporation%20Standard%20Edition%20(64-bit)%20on%20Windows%20Server%202016%20Standard%2010.0%20%3CX64%3E%20(Build%2014393%3A%20)%20(Hypervisor)%26nbsp%3B%3C%2FX64%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20suggestions%20or%20help%20you%20can%20provide.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2040787%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBusiness%20Apps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBusiness%20Intelligence%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EIntegration%20Services%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2042701%22%20slang%3D%22en-US%22%3ERe%3A%20Upgrade%20SQL%20Server%202016%20to%202019%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2042701%22%20slang%3D%22en-US%22%3E%3CP%3EI%20done%20a%20lot%20of%20SQL%20Server%20in-place%20migrations%20to%20newer%20version%20and%20had%20newer%20a%20problem%20with.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20common%20you%20just%20start%20the%20installer%2C%20select%20the%20upgrade%20option%20and%20follow%20the%20installation%20wizard.%3C%2FP%3E%3CP%3EDon't%20forget%20to%20backup%20all%20database%20(incl.%20system%20DB)%20before%20to%20be%20on%20safe%20side.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Finstall-windows%2Fupgrade-sql-server%3Fview%3Dsql-server-ver15%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3E%3CFONT%3EUpgrade%20SQL%20Server%3C%2FFONT%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EOlaf%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Super Contributor

Is there any known issues in upgrading from SQL Server 2016 to 2019? Can it be done by a SQL novice or do you need to have more knowledge to perform the upgrade? We currently are using Microsoft SQL Server 2016 (SP2-CU12) (KB4536648) - 13.0.5698.0 (X64) Feb 15 2020 01:47:30 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor) 

 

Thank you for any suggestions or help you can provide.

1 Reply

I done a lot of SQL Server in-place migrations to newer version and had newer a problem with.

 

In common you just start the installer, select the upgrade option and follow the installation wizard.

Don't forget to backup all database (incl. system DB) before to be on safe side.

 

See Upgrade SQL Server

 

Olaf