Q. Windows Server 2019 upgrade error

Question

I have a question. Help me.

Upgrading server

The in-progress details are: (Windows server 2008 R2 → Windows server 2012 → Windows server 2016 → Windows server 2019)

I have completed until the current Windows server 2016.

When I upgrade from the current Windows server 2016 to the 2019 version, it turns out that I failed as it became 100%.

Please teach me the way.

and

To ask you a further question,

Likewise, we upgraded sql server 2008 to sql server 2019 version, but will the script contents of the procedure be changed?

'uses the old style join syntax which can have poor performance at database compatibility level 90 and higher' This will be displayed.

Answer 1

'uses the old style join syntax which can have poor performance at database compatibility level 90 and higher'

Regarding SQL Server and that message.
"Old style join" is a deprecated feature and not longer supported in version 2019; you have to modify your SQL code.
See https://learn.microsoft.com/en-us/sql/relational-databases/performance-monitor/sql-server-deprecated-features-object?view=sql-server-ver15
=> Non-ANSI = or = outer join operators

Answer 2

The much cleaner / safer / less problematic method is to stand up a new 2019, patch fully, then migrate the roles / applications over to it. You can also review the log files here.
https://learn.microsoft.com/en-us/windows/deployment/upgrade/log-files.

--please don't forget to upvote and Accept as answer if the reply is helpful--